I have one excel file named 'New Client To Do List' which I would like to display information from another spreadsheet named 'Current Transfer Summary' within a different excel file named 'Transfer Tracker Apr 10 to'. I would like information stored in columns I and J in the 'Current Transfer Summary' spreadsheet to appear in columns C and D of the 'New Client To Do List'.
I have played around with the VLOOKUP function but the problem I have is that the two spreadsheets both have some clients that only appear on one spreadsheet. So I need a function that will look at the client name in column A in one spreadsheet and match it to the name in column A in the other spreadsheet before returning the values.
Can anybody help?
Thanks a lot.