Match email addressed (Excel 2003)

Topic

New Reply

I have a file with 2 sheets, Base and NotDelivered. The Base sheet has email addresses in COL M, COL N next to it is blank. On the sheet, NotDelivered, I also have email addresses but in COL A and a date in COL B. I need to match NotDelivered COL A to Base COL M and if there is a match I need to put the date in COL B (NotDelivered) of that email address, into COL N of the Base sheet.. Thank you for the help.

Reply | Quote

Replies

You can use this formula:

=IF(ISNA(VLOOKUP(M2,NotDelivered!$A:$B,2,FALSE)),"",VLOOKUP(M2,NotDelivered!$A:$B,2,FALSE))

Was the reply to post 624,764 useful?

Reply | Quote

got it – once again – arigato

Reply | Quote