CODEWITHSUNDEEP
excel
C C
C C

Reputation: 1

How to correctly search a table based on concatenating 2 table columns in Excel Index/Match Formula

I'm using Index/Match for a table lookup. Looking at the expression function arguments, the function seems to calculate correctly, but the cell displays #VALUE! Match finds the correct table index number. cell formula is:

=INDEX(Cards[PN],MATCH([@ProcessorID]&[@CardName],Cards[ProcessorID]&Cards[CardName],0))

Below is the formula function arguments:

enter image description here

Upvotes: 0

Views: 61

Answers (1)

basic
basic

Reputation: 11968

MATCH with concatenated ranges can only function as an array formula, so after editing press Ctrl + Shift + Enter

Upvotes: 1

Related Questions