Try VLOOKUP with a formula that looks like this in sheet B.

=VLOOKUP(F1,A!A1:B4,2,0)

Where F1 is the lookup value on sheet B and A!A1:B4 is the table_array on
sheet A.

HTH
Regards,
Howard


"Jafferi" wrote in message
...
In Sheet a, i have these info

Employee Number hiring date
122555 apr 5, 2010
152666 apr 4, 2010
123554 apr 4, 2010
451225 apr 5, 2010

In Sheet b, i need this info (that pulls from Sheet a)

Employee Number hiring date
122555 apr 5, 2010
451225 apr 5, 2010

How can I do a formula in Sheet b that will pull all the data from sheet a
for a specific date e.g. apr 5, 2010.