I'm finding Lookup tables to be really helpful, but I still have some issues getting them to work.
Attached is a sample Excel 2007 file. Sheet 1 is a list of documents in Column B. Sheet 2 is another list of documents in Column A, along with additional columns with data that I want to bring to Sheet1.
I need to match the document name on Sheet 2 with the same document name on Sheet1. Then bring from Sheet 2 Columns A, B, C,D & E onto Sheet 1, putting those columns on Sheet 1 starting at column C,D,E,F,G.
If there is no matching document in Sheet 2 then something needs to go into SHeet 1, I guess at column C saying "No match".
So the end result will be Sheet 1 including what is already in Column 1 and using the document name as the "key", and the matching data from Sheet 2,
Hope I am being clear and not over explaining what is actually "simple". At least simple for you!