Help with Match() function
 

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).

Help with Match() function
 

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.

"MandMsRED3" wrote:

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).

Help with Match() function
 

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

"Sloth" wrote:

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.

"MandMsRED3" wrote:

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).