Hello,

I need assistance in writing a formula that does the following:

If the value I enter into cell R3 is the same as just cell A3, then cell U3 needs to populate with the data in cell B3 OR if R3 AND S3 = E3 AND F3 then U3 = H3.

Also, this not for just cell R3, I'll be filling in several rows within R. Up to 481 rows.
Lastly, all information noted above is already loaded in the same spreadsheet (with the exception of what I will be entering in to column R).


Thank you !!!!