lookup in a range then vlookup from the found value onwards

[Guest]

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

 

[Guest]

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