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.
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.