Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup problem
I have a table in my worksheet as follows:
'+1V5' C12809-1 C12810-1 '+1V5_FPGA_dec' R12805-1 C12820-1 TP12844-1 C12821-2 '+1V8' TP11847-1 L11804-2 U11800-6 C11524-1 '+1V8' C11533-1 C11820-1 R11010-1 C11824-1 '+1V8_7020_PLL' C11826-1 U11500-N23 U11500-N22 C11801-2 I have the value I want to find stored in another worksheet. Lets say the value is "C11524-1". How do I search for this value in the current worksheet to get the cell value of the first column in the same row where the value is found. In the above example I should be able to get '+1V8' as a result. I couldn't figure out a way to do this using vlookup or index/match. Any help will be greatly appreciated. Tuncay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP problem | Excel Worksheet Functions | |||
LOOKUP function Problem | Excel Worksheet Functions | |||
Lookup problem want 2 or more results | Excel Discussion (Misc queries) | |||
Zeros problem in LOOKUP? | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions |