Can You Return All VLOOKUP Values?
October 16, 2018 - by Bill Jelen
VLOOKUP is a powerful function. But I often get a question in one of my Power Excel seminars from someone who wants to know if VLOOKUP can return all of matching values. As you know, the VLOOKUP with False as the fourth argument will always return the first match that it finds. In the following screenshot, cell F2 returns 3623 because it is the first match found for job J1199.
The question, then, can VLOOKUP return all of the matches?
VLOOKUP will not. But other functions can.