View Single Post
  #1   Report Post  
ynissel
 
Posts: n/a
Default 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