VLOOKUP?

[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

 

[Jason Morin]

Use INDIRECT. For example:

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

HTH
Jason
Atlanta, GA