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