Pulling data from 2 non identical lists using a unique identifier - help!
Hi,
I have 2 lists, both have a common unique identifier (i.e name). The lists are not identical. List 1 has extra names, and List 2 has a column (column 3) with data (i.e. 5 days) that corresponds to the names, tHis column is not in List 1.
I want to pull the data from column 3 in List 2, in to a new column in List 1, so that it goes into the correct rows acording to its unique identifier. Is this possible?
Can I do this with out sorting both lists first?
Any help is greatly appreciated!
Use Vlookup. Vlookup is split
Use Vlookup.
Vlookup is split into 4 parts as follows:
1)Lookup_Value - in this case Name from list 1
2)Table Array - entire area of list 2 making sure the lookup_value i.e. Name is in the first column of list 2
3)Col_Index_Num - the column no. you want the values returned from within the Table_Array i.e. in this you will enter 3 as the data is the 3rd column in list 2
4)Range_Lookup - enter 0 or False to return values that are an exact match only.
Without seeing sample data unable to write the function for you but it is a simple function to play about with and understand.
Regards
Mark
share the sample data
share the sample data