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!