Excel 2007 : Combing formulas

**ccampbell14** · 07-11-2012, 05:26 PM

I am trying to make this work:
If A2 matches anything in Column C, then D2 should equal the match in B2 (which corresponds with data in A2)

**Pete_UK** · 07-11-2012, 05:32 PM

Put this in D2:

=IF(ISNA(MATCH(A2,C:C,0)),"",INDEX(B:B,MATCH(A2,C:C,0)))

and copy down.

Hope this helps.

Pete

**Richard Buttrey** · 07-11-2012, 05:32 PM

Hi and welcome to the forum.

=IFERROR(INDEX(B:B,MATCH(A2,C:C,FALSE),1),"")

**ccampbell14** · 07-12-2012, 12:14 PM

Thanks for the help! Next question - if I want D2 to list the price vs. a true/false, how is that accomplished?

**Pete_UK** · 07-12-2012, 12:21 PM

Originally Posted by ccampbell14

... if I want D2 to list the price vs. a true/false, ...

I don't know what you mean by that - could you elaborate further?

Pete

**ccampbell14** · 07-12-2012, 02:11 PM

Currently, using either formula, the result lists 'true' if there is a match, but rather than 'true' I would like the actual price [from Column b] to be the result in Column D (if Column A has a match in Column C)

Hopefully this is better clarification