Hello!

VLOOKUP while popular, is not the best way to look up values anymore. Instead, you can use the INDEX and MATCHFunctions in Excel.


=INDEX( I array,MATCH(lookup value, M array, exact match))

I array - the Array, or column where you want to find the value.
look up value - the value you are looking up on
M array - the array, or column, where you are matching the value with
Exact match - 0 for exact match.

This is much better to use and would yield more accurate results. Hope this helps!