Excel IF and MATCH formula?

Hi All,

This is my first time on this forum because I have come across a problem i cannot figure out.

I am using this formula:

=if(match(D5,A2:A1017,0),B2:B1017)


My goal is that if the value in column D matches any value in column A then it gives the corresponding value from column B.


It is currently just giving the B value that is directly across from the cell the formula is in, and not the B value that matches the A value.


Any help would be greatly appreciated. I can't seem to figure this one out.


Thanks in advance,


Blake

Hi Blake,

Try this:


Cheers,

Are you trying to get it to return all of the values that match d5 - and are there more than one value that match? Or are you trying to match one unique value? If it's the latter then CheshireCat has you covered. If you're looking for it to return an array that's a bit different.