Multiple Scenario VLookup

[odonovanc]

What is the formula if I want to do a vlookup and there are multiple scenarios.

I want to lookup say A1 in sheet 2 range A1:F100. If there is an X in column 2 I want to return the value "Text". OR If there is an X in column 3 then I want it to return "Different Text", and if neither column has an X I want it to remain blank "". It will never happen that there is an X in both. Can someone help me write this formula? Thanks.

 

[odonovanc]

=IF(COUNTIFS(sheet2!A:A,A2,sheet2!B:B,"X")>0,"Text",IF(COUNTIFS(sheet2!A:A,A2,sheet2!C:C,"X")>0,"Different text",""))

This worked perfect. Thank you so much.

 

[Fluff]

Glad we could help & thanks for the feedback.