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

[Sepp!]

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!

[Bernie Deitrick]

Sepp,

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

HTH,
Bernie
MS Excel MVP

"Sepp!" <Sepp!@discussions.microsoft.com> wrote in message
news:5A89FF52-0A3D-4B6A-96FD-E58831CE3622@microsoft.com...
> 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!

[spenlinhauer]

THANK YOU!

I have been needing that command for years!

SEPP!