Vlookup combined with an IF statement

[Jbugg]

HI All -

I am trying to perform a VLOOKUP on a value A. Once I find that value A in a range, I need to also check if value B or value C exists in that row under a different column.

I've searched a few threads regarding Index and Match but I'm sure its what i need.

Any help is much appreciated!

 

[AliGW]

Without a sample of the data and an expected outcome, it's impossible to advise.

 

[Jbugg]

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID[/TD]
[TD="width: 64"]Food[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Pear[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Strawberry[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Pear[/TD]
[/TR]
</tbody>[/TABLE]


So basically, I just to look through the data, find ID A and confirm if they are assigned to value "apple" or value "Pear". If yes, then Y. If no, the N. In this case, my cell would populate Y because A is assigned to either Apple or Pear.