Vlookup formula

[pjandshelly]

Hi,I'm looking for a Vlookup formula where I am checking a table. If that value is found, then give me the value in a column that matches the data.

Example:
A B C D
Class ID Class Matching Formula Results
1 Science Math 2
2 Math English #N/A
3 History

Formula that I used =VLOOKUP(D2,$A$1:$B$3,1,FALSE)

This would not give the results that I would like. Am I missing something on this?

 

[Michael M]

It appears you are trying to retrieve data to the left of the search data, in which case VLOOKUP won't work.
You will need to use and INDEX / MATCH function
Your data example is not clear, but have a look at this website for methods of using the INDEX / MATCH

https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/