Indirect formula problem

[SueWithQuestion]

Attached is a sample spreadsheet with a problem formula.

The Indirect formula works fine for matching ids in Section A, which starts at the top of the column, but as soon as I try to find matches in the same column for any section that starts anywhere other than the first row, I run into problems. (See column I for some comments on the errors.)

Can someone tell me what I'm doing wrong?


Thank you for all the quick help!!

[JBeaucaire]

Put this in E2 and copy down:

=IF(ISERROR(MATCH(D2,$B:$B, 0)), "-", INDEX($C:$C, MATCH(D2,$B:$B, 0)))

Then copy E2 to H2, then copy that down.

[NBVC]

Any reason why using INDIRECT?

Try:

=INDEX($C$2:$C$35,MATCH(1,INDEX(($A$2:$A$35="B")*($B$2:$B$35=G2),0),0))

copied down.

Does that work for you?