I have an Invoice I am trying to create. In the 1st coulmn I used a drop
down menu formula that gets the information from another tab.
I have a per unit coulmn with the following formula
=IF(C16="","",VLOOKUP(G16,Product,2,FALSE))
I have a total column with the following formula =IF(F16="","",SUM(F16*G16))
When I choose an item from my drop down menu, I get a circular reference
warning. Can anyone tell me which one of my formulas is bad and how do I fix
it?

In which cells are these formulas located?

What is in G16 or F16 which might be the culprit?

If you look at help on circular references you can see how to navigate
through them and fix them.


Gord Dibben MS Excel MVP

On Thu, 15 Oct 2009 17:34:01 -0700, Kita
wrote:

I have an Invoice I am trying to create. In the 1st coulmn I used a drop
down menu formula that gets the information from another tab.
I have a per unit coulmn with the following formula
=IF(C16="","",VLOOKUP(G16,Product,2,FALSE))
I have a total column with the following formula =IF(F16="","",SUM(F16*G16))
When I choose an item from my drop down menu, I get a circular reference
warning. Can anyone tell me which one of my formulas is bad and how do I fix
it?

The first formula would be circular if placed in C16 and the second if placed
in F16

"Kita" wrote:

I have an Invoice I am trying to create. In the 1st coulmn I used a drop
down menu formula that gets the information from another tab.
I have a per unit coulmn with the following formula
=IF(C16="","",VLOOKUP(G16,Product,2,FALSE))
I have a total column with the following formula =IF(F16="","",SUM(F16*G16))
When I choose an item from my drop down menu, I get a circular reference
warning. Can anyone tell me which one of my formulas is bad and how do I fix
it?