Using Vlookup to look at different names sets of data....
 

Hi,

Trying to create a budget compairison worksheet.
To compare different design layouts against different type of cabinets...

On a sheet that has a design layout, I total the number and types of cabinets.
On another sheet I do the same thing, but it is design 2.

Now I have my budget page that says how much each type of cabinet costs.
I can write a vlookup Like so: =VLOOKUP(A31,Design1,2,FALSE)
Where "design1" is a named range.
What I can't do is: =VLOOKUP(A31,E30,2,FALSE)
Where "E30" = the text value "Design1" (with or without single or double
quotes)
The Vlookup function will not accept the text value to lookup the named
range...

I would love to be able to just change the name of lookup table in one cell.

Any help?

Thanks SEPP!

Sepp,

=VLOOKUP(A31,INDIRECT(E30),2,FALSE)

HTH,
Bernie
MS Excel MVP

"Sepp!" wrote in message
...
Hi,

Trying to create a budget compairison worksheet.
To compare different design layouts against different type of cabinets...

On a sheet that has a design layout, I total the number and types of
cabinets.
On another sheet I do the same thing, but it is design 2.

Now I have my budget page that says how much each type of cabinet costs.
I can write a vlookup Like so: =VLOOKUP(A31,Design1,2,FALSE)
Where "design1" is a named range.
What I can't do is: =VLOOKUP(A31,E30,2,FALSE)
Where "E30" = the text value "Design1" (with or without single or double
quotes)
The Vlookup function will not accept the text value to lookup the named
range...

I would love to be able to just change the name of lookup table in one
cell.

Any help?

Thanks SEPP!