Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Formula help for Vlookup from one sheet to another

on

I am trying to merge information from 2 excel spreadsheets. One contains 30000 rows, the other 3000 rows. Both have a common membership number in one column. I need to look for a match in Sheet1 a3, to Sheet2 Column a, and where there is a match, copy the date in Sheet2 of the same row, to a column in Sheet 1. The closest I have got is not working.....

=IFNA(VLOOKUP(A3,Sheet2!$A$3:$E$3000,4,FALSE),V8)

Any help would be much appreciated. Cheers.

Comments

Post a Comment