Recently a friend of mine said the had a marketing list of names but realized somehow they got one with out the phone numbers only emails. They really needed both. So after contacting the marketing company now they have two lists one with phone numbers and one with emails. Well the original list had been scrubbed so some data was missing. Well it would make it impossible to just add the phone numbers with a quick copy and paste. This is where VLOOKUP comes in. I love this function and was introduced to it by a BA while working with multiple lists of defects that needed information consolidated.
So here is how you do it.
With one excel document with the lists in two tabs. See in this list I have numbers with items and numbers with colors. So in this example i want to see the colors of the items. We will assume the number is a unique number of some kind.
Add the field that is missing in the list in this case I added Item. Then add the vlookup function to that field.
then go into the tab with the missing data and highlight the numbers and the column with the missing data. Go a head and select the entire row.You form should start to look like this.To determine the column index count the column from left to right that you include in your table array till you get to the column with your data. So in this case it was 2. The first column tells it where the match is then the index column tells it what data to grab. Now for the last field I almost always select false because I am looking for exact matches.
click ok. This will insert the function in the field. If you did it right you should have your missing data in the field.