Hello, I'm trying to figure out the correct way to match data in two separate lists. The match is the five digit numbers Once a match is found, then the next column in the second list copies the data from the next column and pastes it to the column next to the match in the first list. For example;
List 1
zone cals
10027 15
10010 32
10036 35
List 2
zones Numb
10036 35
10027 15
10010 32
I would like this to be dynamic if possible because these five digit numbers change. If a match is not found, then I just want it to be ignored. No #NA.
Please advise. Your assistance will be greatly appreciated. I was using vlookup, match with no luck.
Bookmarks