VLOOKUP
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
Or INDEX/MATCH
http://www.ozgrid.com/Excel/left-lookup.htm




--
Regards
Dave Hawley
www.ozgrid.com



"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.