Vlookup Indirect and Circular Reference

[sm789]

Hello All,

Vlookup and indirect has been answered in different posts. My problem is that using Indirect is causing a circular reference. Here is the issue:

In Cell N8 I have VLOOKUP($L8,INDIRECT($BY8),N$4,FALSE)
In Cell BY8 I have VLOOKUP(E8,Depts,2,FALSE)

Basically, E8 cell has the department to which the employee is mapped to.
In Cell BY8, we get the name of the table array based on the department to which the employee is mapped.
In Cell N8, we have a bonus factor based on the information on L8 to be retrieved from Table Array named in BY8.

This causes a circular function.

Can anyone help please?

Thanks.

 

[sm789]

Hello,

I am not sure if I am violating forum rules by sending this reminder. My apologies if I am but I was wondering if someone can please help with this problem?

Thank you,
Sam

 

[jasonb75]

I am not sure if I am violating forum rules by sending this reminder.

There is a recommendation (not a rule) that you wait at least 24 hours before bumping your post in order to avoid appearing impatient, I think it safe to say that you've met that recommendation ?

I don't see any immediate cause for a circular reference in the formulas that you have shown, the formula in N8 refers to the formula in BY8 but the formula in BY8 does not refer back to the formula in N8, which would be necessary for it to create a circular reference error.

The only possibility would be that Depts is referring back to one of the ranges in the N8 formula, or that there is a third (or fourth) formula in the loop causing the circular reference.