Returning an empty cell when no data present

B

Bryan

I know there have been a couple of previous answers to this, but I cannot
seem to make them apply to my situation. I have 2 columns, the 1st pulling
info from another sheet and the 2nd one a calculation using the value of the
first. I am now returning errors in each of these cells because there is no
data present until I enter it. (The spreadsheet is a test-time sheet which
starts out each week empty. Here are my formulas:
=VLOOKUP(A4,Prod_and_Rte,2,FALSE)
=(E4*F4)/C4

Can someone help me return empty cells when no data is present, please?

Thanks,
Bryan
 
P

PCLIVE

Which cell do you want to test for no data. If A4 in your example, then:
=IF(A4="","",VLOOKUP(A4,Prod_and_Rte,2,FALSE))

If C4 in your example, then:
=IF(C4="","",=(E4*F4)/C4)

HTH,
Paul
 
T

T. Valko

Try this:

=IF(ISNA(VLOOKUP(A4,Prod_and_Rte,2,FALSE)),"",VLOOKUP(A4,Prod_and_Rte,2,FALSE))
=(E4*F4)/C4
Click to expand...

Which of those cells is the result of the lookup formula? You need to test
that cell to see if it's blank:

=IF(E4="","",E4*F4/C4)

Biff
 
B

Bryan

Thanks for your help. I just had to remove the third "=" out of the second
formula and they worked perfectly. Thanks so much for the extremely quick
response!

Bryan
 
P

PCLIVE

No problem. I guess I got carried away with the cut and paste.
Glad you got it working.

Regards,
Paul
 
Top