Help with Match() function

M

MandMsRED3

I understand that with a match type of 0, excel finds the first value that is
exactly equal to the lookup value. I need to match the exact value too, but
I would like it to find the LAST value in my range (which is a row).
 
S

Sloth

can't be done with the MATCH function but this array function will do what
you want. Just replace "B" with whatever you are looking for.

{=MAX(COLUMN(A1:F1)*(A1:F1="B"))}

enter it without the quotes and then press ctrl+shift+enter.
 
S

Sloth

I'm sorry. I meant enter it without the brackets. After you press
ctrl+shift+enter it will add them for you.
 
Top