print preview is different than whats on the screen.

G

Guest

In page setup I have selected the <blank> option for cell errors & in print
preview the cells show & print with no data in them. However when viewing
the sheet in normal view the cells have the value #N/A displayed. How can I
get rid of #N/A?
the VLOOKUP formula I'm using is:

=IF((E9>0),G9*E9,VLOOKUP(C9,Pricing!$A$1:$J$5000,7,FALSE))

Thanks in advance for any help,
Chris Hill
 
F

Frank Kabel

Hi
try:
=IF(E9>0,G9*E9,IF(ISNA(VLOOKUP(C9,Pricing!$A$1:$J$5000,7,FALSE)),"",VLO
OKUP(C9,Pricing!$A$1:$J$5000,7,FALSE)))
 

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

Please help on formula that will not work (If-And formula) 3
Screen View differs from Print preview 2
Words wrapped differently on screen and on print preview 4
After Macro runs, no cell activated - what am I missing? 2
How do I delete the print preview page number on the spreadsheet 2
print preview in loop 1
Access 2007: Report formatting different than Print Preview 1
Excel > page setup > Sheet > Print > Cells Error As... 2

Top