vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale G - 16 May 2008 17:01 GMT

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

Reply to this Message

Max - 17 May 2008 21:44 GMT

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(Feeder!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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 15 lines]
> 938 14:50
> 972 15:03

Reply to this Message