RSteeg
asked on
Vlookup in Excel
When I build a vlookup in a cell on an excel spreadsheet, it returns the formula instead if the looked up value.
Check the cell is not formatted as text.
Are you putting an equal sign in front of Vlookup? (=VLOOKUP("Sample",B5:C7,2 ,False)
Flyster
Flyster
can you post the sheet ?
ASKER
I have attached the spreadsheet
... where is it ?
ASKER
Sorry, here it is. I am trying to do the lookup in column "O" on the physicians tab.
physicians.xlsx
physicians.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.