Index & Match Formula to provide row number if found in column

IB3

=IF(INDEX(ColumnA:ColumnA,MATCH(ColumnB@row, ColumnB:ColumnB,0), INDEX(Auto:Auto, MATCH(Auto@row,Auto:Auto, 0), "")))

Auto = System column to pull row number

ColumnA =Text

ColumnB =Text

ColumnC= Formula location & Row Number Output

So, what I’m trying to achieve is to have a formula to Lookup ColumnA text and match ColumnB text. If there is not a match, it returns blank, but if there is a match, to return the Auto of ColumnA.

 

I’m sure I’m overlooking something easy here, as I’m receiving an #INCORRECT ARGUMENT but I would be welcome for your assistance!

Paul Newcome

Try this:

=IFERROR(INDEX(Auto:Auto, MATCH(ColumnB@row, ColumnA:ColumnA, 0)), "")

Paul Newcome

Try this:

=IFERROR(INDEX(Auto:Auto, MATCH(ColumnB@row, ColumnA:ColumnA, 0)), "")

IB3

Thanks Paul! You always know how to figure these types of fixes! lol

I dropped it in, and it's returning "1" for all of the values expect the one that matches. Is there an easy fix to make sure that the column doesn't return any value? (Blank)

IB3

Hi Paul! Nevermind, I figure it out! lol

I've been staring at computer screens too much! Thank you again for your amazing help!😅