Excel Formulas

Use INDEX / MATCH vs. VLOOKUP

IFERROR((INDEX('BD-CMDB-AppLookupGUID'!$A$2:$M$6000,MATCH($B4,'BD-CMDB-AppLookupGUID'!$C$2:$C$6000,0),4)),"Missing Data")

Generic Formula:

Essentially - A2:M6000 is the entire sheet to search. B4 is the column to look up. Match what is found in the entire column C2:C6000 and bring back the content found in Column 4.

IFERROR((INDEX('WORKSHEET-NAME'!$A$2:$M$6000,MATCH($B4,'WORKSHEET-NAME'!$C$2:$C$6000,0),4)),"Missing Data")

We use the MATCH INDEX functions with multiple criteria by following these 5 steps:

Step 1: Understanding the foundation

Step 2: Insert a normal MATCH INDEX formula

Step 3: Change the lookup value to 1

Step 4: Enter the criteria

Step 5: Ctrl + Shift + Enter

IFERROR((INDEX(ExportedData!$B$25:$Y$45,MATCH($D10,$D$9:$D$100,0),20)),"ERROR")

Index Match Formula

=iferror((index($A$1:$D$100,match(X1,$A$1:$A$100,0),2)),"ERROR")

Multi criteria

=iferror((index($A$1:$D$100,match(X1&Z1,$A$1:$A$100&$B$1:$B$100,0),2)),"ERROR")

If you use the multi you need to hit ctrl enter otherwise it won't work.