LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP problem Kaylean Excel Worksheet Functions 13 May 5th 09 03:51 PM
Excel 2007 lookup problem continuing ... Trish Excel Worksheet Functions 3 August 5th 08 05:46 AM
Lookup problem murrmeik Excel Worksheet Functions 2 May 13th 08 07:33 PM
Excel 2007 LOOKUP Problem? robertbjr Excel Worksheet Functions 3 March 18th 08 06:32 PM
HELP -- probably a LOOKUP problem Liz-In-USA Excel Discussion (Misc queries) 3 December 9th 04 12:18 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"