Hello All,
I would like some help with the VLOOKUP function....
I am trying to use the VLOOKUP function in Excel to display the TOP Code of a course. In the TOP Code column in Sheet 1, I want to find a course that exists in Sheet 1 and Sheet 2, then display its corresponding TOP Code from Sheet 2 in Sheet 1.
In the attached file, I made two VLOOKUP function formulas that do not seem to be working properly. The one next to "ACCT 001" omits TRUE/FALSE and therefore gives an incorrect TOP code of "0502.10* Tax Studies." It should be "0502.00* Accounting."
In the second VLOOKUP function formula, I added FALSE to look up an exact match of "ACCT 002" in Sheet 2 but the result is a #N/A error.
I also tried the following INDEX/MATCH function formula but it gave me similar incorrect results: =INDEX(Sheet2!B:B,MATCH(Sheet1!A6,Sheet2!A:A))
I am not sure what I am doing wrong. Any help is greatly appreciated.
Bookmarks