| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup numbers in sheet and assign it's cell reference
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I assign a unique ID number to an invoice sheet I created? | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do you assign clip art to a cell? | Excel Worksheet Functions | |||
| Variable VB to assign new sheet name | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Threaded Mode
