I put together a spreadsheet with names and addresses and other things.
At some place down the road I accidentally deleted the column with the FIRST NAME of the person.
So what I want to do is to restore the first name of the person based on the earlier file I have.
I want to base the first name on two criteria:
1) The last name and street address on Sheet I need both to be 100 percent sure that I am associating the correct last name with the restored first name.
2) Sheet two contains the first name, last name street address and other data. It is in a different order and also contains names that are not on Sheet 1. Also the columns are different in sheet 2 then sheet 1. But I figure a lookup table would have no trouble taking care of fixing my missing first name goof.
That's why I am looking at a lookup solution to solve this.
I have about 2 thousand names and addresses where I need to restore the first name. The attached file has only a few names, but that will be enough to figure out the lookup formula.
I think my question is pretty straight forward. If you could look at the attached file and show me how to do the lookup table -- I will transfer it to my real file. I modified the names and addresses for privacy purposes.