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