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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Adding VLOOKUPS across multiple worksheets 3
Vlookup and return sheet name also 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
Vlookup to reference offset 1
Runtime error 1004 when trying to insert formula in cells 11
How can I make a vLookup dynamic? 1
Alternative of Vlookup function which improves speed 4

Back
Top