Hi!

Glad we got that data validation deal worked out!

Ok.........

In sheet "Location" assume the bus numbers are listed starting in B2. Enter
this formula in Location C2 as an array using the key combo of
CTRL,SHIFT,ENTER:

=ADDRESS(MAX((Shed!B$3:E$46=B2)*(ROW(Shed!B$3:E$46 ))),MAX((Shed!B$3:E$46=B2)*(COLUMN(Shed!B$3:E$46)) ))

Copy down as needed.

Biff

"dgraham" wrote in
message ...

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