Drop down and vlookup from another sheet

0

I am creating an invoice with multiple areas that each have a different price for each item. I would like to be able to select from the drop down and use vlookup to look up the description and amount for the area selected in the drop down from another sheet. Can anyone help?

So what I would like to be able to do is where it says Emergency Invoice Area: In the drop down menu, when N03B is selected and I move down to Unit and description to use vlookup i want it to pull the prices from the sheet labeled N03B. The same goes for each area. 

Answer
Discuss

Discussion

If you attach a sample sheet, I'm sure someone will be able to help.
gebobs (rep: 30) Jun 26, '17 at 3:28 pm
Add to Discussion

Answers

0

Using the INDIRECT function, you can adjust your IF statements to this:

=IFERROR(VLOOKUP(B16,INDIRECT(C13 & "!A2:D114"),2,FALSE)," ")

That replaces the formula in cell C16 and you can follow this pattern for the other cells.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login