Updating ID Number from Another Excel

I was able to do it, thank you for reminding me of vlookup.

Here's the formula I used

=VLOOKUP(updateme!A2,ref!A2:B6729,2)

updateme being the first excel and ref being the second excel.


thanks!!!!