Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup in a range then vlookup from the found value onwards
I would like to lookup a value in a column, and then from that value onwards
lookup a text. A sort of then function should be included between functions but I can't manage! please help asap!! Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup in a range then vlookup from the found value onwards
Your question is not clear. VLOOKUP allows you to find a value in a table
that is in column 1, and returns a value from another column in that same row. Sounds to me that this is what you need...read help on vlookup if what you want is to use the found value to get data from another table, then simply use the first result within a second vlookup example = VLOOKUP( _ what1, _ where1, _ column1, _ false) = VLOOKUP( _ VLOOKUP(what1, where1,column1,false), _ where2, _ column2, _ false) where1 and where2 are the table names. HTH Patrick Molloy Microsoft Excel MVP "Jeanette" wrote: I would like to lookup a value in a column, and then from that value onwards lookup a text. A sort of then function should be included between functions but I can't manage! please help asap!! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup using dates in the lookup range | Excel Worksheet Functions | |||
VLOOKUP using a tab name to reference the lookup range | Excel Discussion (Misc queries) | |||
Vlookup problem in lookup range | Excel Worksheet Functions | |||
VLOOKUP range lookup | Excel Worksheet Functions | |||
Range Lookup in VLookup ?'s | Excel Worksheet Functions |