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.