Forum Discussion
TRUE vlookup brings the wrong results
Hello to all,
I wanted to make my full-of-vlookups workbook faster so I thought I would start using vlookups(TRUE) on a sorted table since I read that its faster that way.
Problem is that...
Hi. It might be that the item you are looking up is in the data multiple times. In which cases the vlookup will return the value for the first instance it finds.
In my case the vlookup is being done on a power query table which has any duplicate entries removed.
Just to be clear,
the table where the vlookup is being done 'from' is not sorted
the table that the vlookup looks 'to' is sorted with unique values in each cell.
Just to be clear,
the table where the vlookup is being done 'from' is not sorted
the table that the vlookup looks 'to' is sorted with unique values in each cell.
