View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Asoka Walpitagama - Brandix College IT Asoka Walpitagama - Brandix College IT is offline
external usenet poster
 
Posts: 15
Default 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