INDEX/MATCH to replace VLOOKUP Excel

 VLOOKUP has many problems searching, one of them is thatsn't allow to search fields in left of searching column.

 

=INDEX(columnToGetValue, MATCH("Value", columnToSearchValue, 0), 1)

 

- columnToGetValue: column where do you need to get the value (parallel to search column)

- "Value": value to look for

-  columnToSearchValue: column where do you need to search the value

- 0: constant for exercise

- 1: You can change the 1 with many positions to the right column to get value.

Example in Excel (with ; instead of ,):

=INDEX(Sheet1!$C$1:$C$200; MATCH($F3; Sheet1!$A$1:$A$200; 0); 1)

References:

- https://trumpexcel.com/vlookup-vs-index-match/

- https://exceljet.net/index-and-match