Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have some data in the following format: Ref Date 001 01/05/08 002a 10/05/08 002b 08/05/08 002c 12/05/08 I'd like a formula to use in another table that looks up anything with a ref starting 002 and returns the earliest date (08/05/08). Any help gratefully appreciated. Thanks, Gavin. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with a Lookup formula ? | Excel Worksheet Functions | |||
lookup formula | Excel Discussion (Misc queries) | |||
row lookup formula | Excel Worksheet Functions | |||
Lookup formula? | Excel Discussion (Misc queries) | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |