Hi guys (and gals),
I am a noob here and just venturing into the novice level of using vlookups in Excel.
I am comparing a current master list (Sheet2) with a new list(Sheet1) and trying to identify the values from Sheet2 so that I can update Sheet1.
The formula I have started using is
=VLOOKUP(A2:A6758,Master!B2:D6128,4,FALSE)
When I enter this, I am receiving #N/A.
Can someone help?
Thanks,
I am a noob here and just venturing into the novice level of using vlookups in Excel.
I am comparing a current master list (Sheet2) with a new list(Sheet1) and trying to identify the values from Sheet2 so that I can update Sheet1.
The formula I have started using is
=VLOOKUP(A2:A6758,Master!B2:D6128,4,FALSE)
When I enter this, I am receiving #N/A.
Can someone help?
Thanks,