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

Regards,
Paul

"Bryan" wrote in message
...
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

"PCLIVE" wrote:

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

"Bryan" wrote in message
...
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