Forum Discussion
Solved
Vlookup not selecting first cell from top.
Hi, I have a table with more than one match for the Lookup_value. If there are four matches, then the result returned is from the last match found and not the first. I've solved this be sorting...
See the attached version. It has VLOOKUP with FALSE as 4th argument and XLOOKUP.
Hi
All the discussion is correct, but these days I would use xlookup as it is much more flexible. However, there will always be a problem where the value being looked up occurs many times and has different values related to that lookup that need to be returned.
I have had this in the past (years ago) and there are two resolution. Firstly you have to determine a way that makes the lookup value a unique reference. Or secondly do you really want a lookup, is it in fact an average or a count or some other information that is needed?
I hope this helps
Regards
Paul
All the discussion is correct, but these days I would use xlookup as it is much more flexible. However, there will always be a problem where the value being looked up occurs many times and has different values related to that lookup that need to be returned.
I have had this in the past (years ago) and there are two resolution. Firstly you have to determine a way that makes the lookup value a unique reference. Or secondly do you really want a lookup, is it in fact an average or a count or some other information that is needed?
I hope this helps
Regards
Paul