Vlookup within a vlookup
 

I am trying to lookup a cell within a table - but the table to use is found
in another table.
=VLOOKUP(B3,VLOOKUP(B2,F3:G9,2,2),2)

Cell B2 is a dropdown box allowing one of the choices in colum f below.
Column G represents which table to use for the initial lookup based on your
choice in the drop down dox.

column f column g
Alt A 30 Yr fixed30
Alt A 15 Yr fixed15

All I get is an error - can someone help ?
Thanks,
Yosef

It sounds like you would need to use INDIRECT within the lookup formula

http://tinyurl.com/czxtt

that thread shows the way to do it except for that the cell ref in that
thread represents a sheet name but it can be adapted to work with a table
name


Regards,

Peo Sjoblom

"ynissel" wrote:

I am trying to lookup a cell within a table - but the table to use is found
in another table.
=VLOOKUP(B3,VLOOKUP(B2,F3:G9,2,2),2)

Cell B2 is a dropdown box allowing one of the choices in colum f below.
Column G represents which table to use for the initial lookup based on your
choice in the drop down dox.

column f column g
Alt A 30 Yr fixed30
Alt A 15 Yr fixed15

All I get is an error - can someone help ?
Thanks,
Yosef

took me a bit - but this worked great ! thanks

"Peo Sjoblom" wrote:

It sounds like you would need to use INDIRECT within the lookup formula

http://tinyurl.com/czxtt

that thread shows the way to do it except for that the cell ref in that
thread represents a sheet name but it can be adapted to work with a table
name


Regards,

Peo Sjoblom

"ynissel" wrote:

I am trying to lookup a cell within a table - but the table to use is found
in another table.
=VLOOKUP(B3,VLOOKUP(B2,F3:G9,2,2),2)

Cell B2 is a dropdown box allowing one of the choices in colum f below.
Column G represents which table to use for the initial lookup based on your
choice in the drop down dox.

column f column g
Alt A 30 Yr fixed30
Alt A 15 Yr fixed15

All I get is an error - can someone help ?
Thanks,
Yosef