Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Vlookup
excel xp training - Vlookup
Resolved · Low Priority · Version Standard
Vlookup
What reason is there that my vlookup finds some data but not others? Could this be something to do with cell formatting?Thanks!
For upcoming training course dates see: Pricing & availability
RE: Vlookup
Hi JenniferDo you get any error messages coming up in your spreadsheet in the cells where the Vlookup is not working properly?
Perhaps if you could provide a bit more information about your problem we might be able to solve it.
thanks
Amanda
RE: Vlookup
I think that you may get the wrong results by not having the last (optional) part of the formula that allows the table to be in ANY order rather than strict numerical/alphabetical. Without it, it will find the first/closest match then stop.
|
|
» Forum post: Charts |



Course updates

