Thread
:
Vlookup gives wrong answers when used in large data. Pls advise?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
Vlookup gives wrong answers when used in large data. Pls advise?
Another common problem is forgetting to use absolute references for the
lookup table range.
Hope this helps.
Pete
Reply With Quote