VLOOKUP?

U

Ulrich

Hey
I need to have a variable part in this vlookup formula:
VLOOKUP($C9,CDE!$B:$N,3,FALSE)
the CDE!$B:$N bit should be variable (different tabs) through a drop down
menu, or replaced by a cell, say D4 which represents a different range.

Thanks for your help!

Ulrich
Iver
 
J

Jason Morin

Use INDIRECT. For example:

=VLOOKUP(---,INDIRECT(D4),---,---)

HTH
Jason
Atlanta, GA
 
Top