| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to retrieve dates from lookup
I am trying to do a lookup formula with if then... =If(hlookup("1C",
B1:B10,1,False),lookup("1C",B1:B10,1) Here is my data: 3/1/05 3/2/05 3/3/05 3/05/05 1C 1C With this information, I want to be able to find all the cells that have "1C" and return with the date that corresponds to it. For example: "1C" is in both the dates 3/1/05 and 3/3/05. I want a formula that will retrieve those two dates. And if there aren't any "1C", then I want to get a blank cell or a N/A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
| Scheduling employees by dates... LOOKUP or FILTER? | Excel Worksheet Functions | |||
| How do I retrieve a date in a column of dates which > my criteria | Excel Worksheet Functions | |||
| How to lookup the dates of a list that are only the first of the . | Excel Worksheet Functions | |||
| Lookup a date between other dates | Excel Worksheet Functions | |||
Threaded Mode
