IF function - display cell from another worksheet

Hello, please help!
I have an IF function that I need to link to a cell in another worksheet.
The formula I am using is:

=IF(D30="Lg Doc Copies","Pricing!B7")

D30 in the one worksheet says Lg Doc Copies (yes I am sure :P)
D30 just stays blank, but I want it to display the content of B7 in the Pricing worksheet.

Much thanks!

Yes I did try removing the quotation marks. It still did not work. The formula is going in A30.
In short, I want this to happen:
If B30 says Lg Doc Copies, I want A30 to display the cell contents of B7 in the Pricing worksheet.

This is the FULL formula I am using (note: it worked perfectly before trying to reference another worksheet):

=IF($B30="","", IF($B30="Lg Doc Copies","Pricing!B7",IF($B30="8x11 BW","0.20",IF(B30="11x17 BW",".30",IF($B30="8x11 Color","1.00",IF($B30="11x17 Color","2.00",IF($B30="12x18 BW",".40",IF($B30="12x18 Color","2.50",IF($B30="Line Color Plots","1.50",IF($B30="Medium Color Plots","3.00",IF($B30="Full Color Plots","5.00", IF($B30="BW HP Plots", "1.50", IF($B30="Lg Scans - 1-5", "5.00", IF($B30="Lg Scans - 6+", "5.00", IF($B30="Sm Scans", ".50", IF($B30="Laminate", "4.00", IF($B30="Blank Cardstock", ".35", IF($B30="BW Cardstock", ".50", IF($B30="Color Cardstock", "1.50", IF($B30="8x11 Clear Cover", "1.50", IF($B30="Cerlox - 1/4, 1/2, 5/16", "2.00", IF($B30="Cerlox - 5/8, 3/4", "2.75", IF($B30="Cerlox - 1", "3.00", IF($B30="Cerlox - 1 1/4, 1 1/2", "3.50", IF($B30="Cerlox - 1 3/4, 2", "4.00", IF($B30="Duracopy", "2.50", IF($B30="Mylar BW", "3.50", IF($B30="Mylar Color", "5.00", IF($B30="Canvas", "8.00", IF($B30="Vellum", "1.50"))))))))))))))))))))))))))))))

bumpbumpbump

jaideb:

That nested if formula is quite long. I would use a vlookup table to get the data you wanted. I don't know what the rest of your worksheet looks like since it wasn't posted, but I made a sample worksheet with 3 tabs (Main Sheet, Lookup Table and Pricing). In the Lookup Table tab I added all of your possible choices (Lg Doc Copies through Vellum) and their corresponding values (.20 to 1.50). I took all that from your If statement. Next, I used that in Cell B30 of the Main Sheet tab to make a dropdown. Once a value is selected from the dropdown, the formula in cell A30 uses a vlookup to pull the right value. As for Cell B7 in pricing tab, I simply made the lookup table for Lg Doc Copies point to the Pricing!B7 cell to pull it's value.

This way, you can more easily update your lookup table if details change, and don't have to worry about updating that if statement.

Does that help?

Josh

That is awesome Josh thank you! That formula is great for the basic pricing!

However, the main issue that I am trying to address is we have many customers with different pricing. I am trying to link to the worksheet with specific customer pricing. I am attaching my basic spreadsheet, maybe you can see a way for me to do this effectively.