Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL LOOKUP PROBLEM
In the following data set I need to fill the 'START DATE' column (F) with the
dates ( in columns B - E ) where the first number appears as shown below Eg. CODE 1 will have 3-Jan-09 because the first number (600) appears on D col. where the date is 3-Jan-09 A B C D E F 1-Jan-09 2-Jan-09 3-Jan-09 4-Jan-09 START DATE CODE 1 600 700 3-Jan-09 CODE 2 - 400 333 - 2-Jan-09 CODE 3 - - - 232 4-Jan-09 CODE 4 222 - 454 4545 1-Jan-09 CODE 5 - 333 - - 2-Jan-09 CODE 6 - - 444 2323 3-Jan-09 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP problem | Excel Worksheet Functions | |||
Excel 2007 lookup problem continuing ... | Excel Worksheet Functions | |||
Lookup problem | Excel Worksheet Functions | |||
Excel 2007 LOOKUP Problem? | Excel Worksheet Functions | |||
HELP -- probably a LOOKUP problem | Excel Discussion (Misc queries) |