Hi,
I have two tabs and I'm looking for the formula to insert in column R on the first tab. See first screenshot.
Then, I have data in the second tab, with two conditions and status. See second screenshot.
This formula should compare entries across two tabs and then pull the corresponding status from column H (tab 2) into column R (tab 1). See third screenshot for the desired result.
Appreciate your help with the working formula
I have two tabs and I'm looking for the formula to insert in column R on the first tab. See first screenshot.
Then, I have data in the second tab, with two conditions and status. See second screenshot.
This formula should compare entries across two tabs and then pull the corresponding status from column H (tab 2) into column R (tab 1). See third screenshot for the desired result.
Appreciate your help with the working formula