If Function and Vlookups

  • Thread starter Thread starter Kita
  • Start date Start date
K

Kita

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
 
Back
Top