| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup problems
I've not used Lookup before and having troble to get it to work with the following table. Sheet 1 A1 = bus123 B1 = Bus Yard Sheet 2 Yard 1 Yard 2 Yard 3 bus45 bus123 bus99 bus12 bus08 bus122 bus001 bus002 bus45 bus09 The value to lookup is Cell A1 - $A$1 and I want the yard which the bus is in to be entered in to B1. I don't think this can be done with only lookup. Is there anyway to solve this using a function using IF ELSE? -Joe -- nrussell ------------------------------------------------------------------------ nrussell's Profile: http://www.excelforum.com/member.php...o&userid=23731 View this thread: http://www.excelforum.com/showthread...hreadid=374639 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup problems | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| lookup problems | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
