I have attached a spreadsheet with two lists of data. I want to use a lookup table or something useful to match mulitple data.
It's hard to explain, but I will try. I want to use lookup table to add a entry to the result field if it matches the ref, start date & end date with a adjustment number from that lookup table.
Example
First List
Ref Start Date End Date Result
100046684 03/04/2006 25/03/2007 (it would look at the lookup table and enter a 4 for adj no)
Lookup Table
Ref Start Date End Date Adj No
100046684 03/04/2006 25/03/2007 4
I hope you understand what I am trying to do.
Thanks
Nick
Bookmarks