vlookup
 

I have a workbook with multiple sheets, each sheet in column (A) has a three
digit number that is assigned for a piece of work. Column (B) will describe
the vehicle used for that piece of work. the purpose of these sheets is to
track the time of the piece of work, at a location. The piece of work appears
at the location multiple times each day, but each day a different vehicle is
assigned. I made a sheet called (feeder) with the piece of work numbers in
column (A). I want to use column (B) to enter the vehicle number, then have
that automatically feed the rest of the sheets.

Run # Bus # Time
958 14:00
850 14:08
312 14:20
936 14:20
970 14:33
722 14:38
930 14:39
938 14:50
972 15:03

vlookup
 

Presuming "Runs" are in A2 down in each sheet, think you could group all the
sheets (except the sheet: "Feeder"), then place in B2:
=IF(ISNA(MATCH(A2,Feeder!A:A,0)),"",IF(INDEX(Feede r!B:B,MATCH(A2,Feeder!A:A,0))=0,"",INDEX(Feeder!B: B,MATCH(A2,Feeder!A:A,0))))
Copy B2 down as far as required. Then ungroup the sheets.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dale G" wrote:
I have a workbook with multiple sheets, each sheet in column (A) has a three
digit number that is assigned for a piece of work. Column (B) will describe
the vehicle used for that piece of work. the purpose of these sheets is to
track the time of the piece of work, at a location. The piece of work appears
at the location multiple times each day, but each day a different vehicle is
assigned. I made a sheet called (feeder) with the piece of work numbers in
column (A). I want to use column (B) to enter the vehicle number, then have
that automatically feed the rest of the sheets.

Run # Bus # Time
958 14:00
850 14:08
312 14:20
936 14:20
970 14:33
722 14:38
930 14:39
938 14:50
972 15:03