INDEX MATCH FORMULA

LeAndre P

Hello,

I'm using the following formula in one of my sheets. The expectation was to have the formula compare random entries within the {WARRID} and [Claim ID]:[Claim ID] column and when a match was identified return the cell value contained in the {POTTL} column for the matched row. So far I have not had any luck.

=INDEX({WARRID}, MATCH([Claim ID]:[Claim ID], {POTTL}, 0))

The source sheets currently do not contain any matching entries so I expected to see "no match" returned however, the formula is returning #INCORRECT ARGUMENT. What am I missing?

Thanks in advance,

LeAndre P

I managed to get this one solved using the following formula.

=IFERROR(INDEX({POTTL}, MATCH([Claim ID]@row, {WARRID}, 0)), 0)

Regards,

Genevieve P.

Hi @LeAndre P

Well-done! I'm glad you were able to figure this out. 🙂

LeAndre P

I managed to get this one solved using the following formula.

=IFERROR(INDEX({POTTL}, MATCH([Claim ID]@row, {WARRID}, 0)), 0)

Regards,

Genevieve P.

Hi @LeAndre P

Well-done! I'm glad you were able to figure this out. 🙂