The formula vlookup should do that.
If you want to find the name "John" in column A on sheet 1, the
formula would be:
VLOOKUP("John";Sheet1!A:B;2;FALSE)


Per Erik


On Thu, 9 Aug 2007 16:14:01 -0700, Jacque Young <Jacque
wrote:

I have 15 individual trackers that contain names (A1 -A700) and then data for
those individuals in B1-E700. I want to pull the data from B1-E700 if present
to a master tracker. Tricky part is the location and place on the individual
trackers may vary month to month. Can I have a formula that will search for
the name amonst all trackers and pull the data if present to the master
tracker? Please help I am going insane.