Hello,
I am after some help again, I have a worksheet(Shed) and the range
where numbers will be entered are B3:E46. In another sheet(Location) I
have a in column A "Shift #", B "Shift Bus #" C "Location". what I am
attempting to do is when a bus number is entered into Shed! ie..
b3=900, d15=350 etc.... Location! would lookup ie.900 in the Shed! and
match it to Location! (column B) and from there provide the cell ref in
column C. So I could then print Location! that would give me in Shift #
order where each Bus # the shift is assigned to.
Thanks for any assistance
Regards
David
--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread:
http://www.excelforum.com/showthread...hreadid=530335