Assuming data on sheet1 starts in row 2...

=VLOOKUP(A2,'Sheet2'!A2:B100,2,FALSE)

If a match is not found, this will return an error.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nrva" wrote:

I have 2 sprdsheets & I know where to find VLookUp Fnctn, but I'm not sure
what to enter in every line;
I need to 'Bump Up'-match the loan #s on my existing Excel Sprdsheet via
using data from 2nd spreadsheet (column 1 (loan#s) & column 2(status of this
loan#s). So new loan #s with their status will appear separately & the loan
#s that match will show their new updated status.
Thank you in advance.