So I am trying to come up with a formula that uses one cell as a reference, checks another sheets column for a match and if found check that same row but in other columns for values and if both conditions are met, enter specific text. For example:
Use cell B2 from Sheet Joe's Truck for reference. Formula to go in Cell C2 (Status)
If match is found in column A on Warehouse sheet AND Joe is entered in the same row column B on that sheet enter the text "SIGNED OUT"
If match is found in column A on Warehouse sheet AND Joe is entered in the same row column B AND value is entered in Column C, enter the text "INSTALLED"
I have tried several IF, AND, COUNTIF and MATCH formulas but I just can't seem to get it right.
Thanks in advance for any help :)