I have 2 sheets. I need to compare F92 of Sheet-1 with Sheet-2 range from
F21:F9300. If there is a match then I need to see corresponding value in cell
I of sheet-2. If that value is X or R, then on Sheet-1, next to F92 I need to
insert Yes into G92. I need to check Sheet-1 F92 thru F1893. As a result, I
will see some "Yes" in column G of sheet-1.
How can I do this?
Thank you.