Excel to match information by date

[GhostZulu]

Hi,

I have searched the forums for minutes + I cannot find a way to make.... example:

Sheet1 cell: B3 B24 B45 B66 B87 (IF they all show the same date) I would like them to populate the data from C3 D3 E3 F3. or their info vertically Such as a vlookup

This info will populate to another Sheet: However I want the info from these cells to populate to C1 C2 C3 C4 C5 Ect.

Thank you for your help

[FDibbins]

without having a sample to look at, its hard to see what you need and where you need it, but try something like this )im sure 1 of the guru's can come up with a more eligant sollution though)....

=IF(AND(B3=B24,B24=B45,B45=B66),"what_you_want_for_a_match","what_to_do_if_no_match")

[GhostZulu]

Thank you, I wish to be a pro at this, I am years behind.

So can I include the same formula from lets say 10 sheets and still have only the colums with the correct date show?

Thanks

[FDibbins]

again, without seeing sample data and what you are trying to do, its hard to "picture". I would suggest try it, with the sheet names added, and see how it works? you can nest mulitpe "matches" in an and() statement, and you can either "leap-frog" them like i did above, or reference them all back to B3.

let me know how you make out, and shout if you need more help