Hello, Please could anyone help? Attached please find the example.
The sheet (in document 2) is seperated into 3 parts: part 1: The second column has codes starts with MLR (yellow background) -> look up data on document 1 ( column 4 & 5).
part 2: The second column has codes starts with SP (yellow background)-> look up data on document 1 ( column 3 & 4 & 5).
part 3: All the data with blue background.--> look up data on document 1 ( column 2).
Since data would be updated weekly, how can i let the excel know which data belong to which group.( i.e. if i add a new selection no. to second column (say MLR2001 with yellow bg) , how could i tell excel that it belongs to yellow part and to look up data from document B ( column 4 & 5).
Or are there any method that can allow me to do so? (e.g add an column with # which indicate the group the selction no( column 2) belong to) Any method is OK as long as i can tell excel whereabout it should look up (column 4 & 5)or ( column 3 & 4 & 5) or ( column 2).
Examples: http://www.speedyshare.com/files/23160746/1.xls
There are 3 empty columns in the document "2", and i have to insert the data from document "1" . The document "2" is seperated into 3 parts as i mentioned. And i want excel to look up automatically the different colums according to whether its " yellow+start with M" or "yellow +start with S" or "blue". Because this document needs to be update weekly ( add more values on column 2 of document 2) , i need excel where to look up each time and have the background of the tab shaded accoring to document 1. I know its quite confusing, but i really appreciate any help! Thanks!!
P.S. column B in Document 2 and column A in Document 1 is the data that i want to match up. Thanks!