Hi,
I'm hoping someone can help.

I have a spreadsheet "A" with 5-digit numbers in column A and there are over 10K rows.

Then I have a spreadsheet "B" with 5-digit numbers in column A and there are only 223 rows.

IF a value in spreadsheet A column A matches spreadsheet B column A, I'd like spreadsheet B column B to log "U". If not, I'd like spreadsheet B column B to log "R." At the end of the day, I'd like all 223 rows in spreadsheet B column B to have either "U" or "R" assigned. Could someone please help?

Thanks!
~S