If Function and Vlookups

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?
 
G

Gord Dibben

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
 
A

Atishoo

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

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

IF(AND problem to work out commissions 7
Rounding Errors in 2007 14
Cumulative formula for word table 0
Timecard - Calculating Time Error 16
How do I create "IF" function with a drop down list? 10
trying to update a cell with new data based on vlookup functions 0
VLookup sum multiple matches 1
Iserror with if(or & Vlookups 5

Top