I have dates from B1:B10 and underneath each date it has either blank cells
or it has "1C" , "2C", "3C" underneath it. Now I want to retrieve all the
dates that have "1C" underneath it.

Are you sure you're describing this correctly?

Did you mean you have dates in B1:J1 and in B2:J2 you have either empty
cells or the codes?

Biff

"MRT" wrote in message
...
I have dates from B1:B10 and underneath each date it has either blank cells
or it has "1C" , "2C", "3C" underneath it. Now I want to retrieve all the
dates that have "1C" underneath it.

"Biff" wrote:

Where EXACTLY is this data?

In your formula you use a range of B1:B10 but the sample data doesn't
look
like it follows that layout at all!

Biff

"MRT" wrote in message
...
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