I have created the following formula, but it is not working properly, it Shows an error "Circular Reference Warning".

=VLOOKUP(B2,$A$10:$B$13,2,FALSE)+(VLOOKUP(D2,$B$10 :$C$13,2,FALSE)*C2)

So, like in the title, please can you look at the image or the excel file, you will know what I mean.

I want to calculate: First find the department's salary
(ex. B2 is dept 200, which has salary of 10000 (from B11) )
and to the salary add the commission (C11) which should be multiplied by Sales (C2). This formula has to use Lookup function!!!



It is for the class assignment, so it has to contain Lookup formula.

Thanks

Attached Images

lookup formula.jpg (99.9 KB, 16 views)

Attached Files

The file.xlsx (11.1 KB, 16 views)