Circular Reference Error on an hlookup formula

[gregfetzer]

I keep getting a circular reference error on my hookup formula:

=hlookup(L2,V7:Z10, 2, TRUE)

I think it's wanting to calculate itself??

in column L I want to use a hlookup, with a match, to determine each students advisor.
The Advisors are listed in my Advisors Table (V7:Z10)
I need to use hookup to find the Major and then use a match function in the row_index_number

Any assistance is appreciated.

[Moo the Dog]

Do you have a sample sheet you could upload?

[gregfetzer]

Yes, please see attached....

[Moo the Dog]

OK, first thing is this, you have that formula IN cell L2. HLOOKUP requires a LOOKUP_VALUE - and that LOOKUP_VALUE cannot be in the same cell as the function.

I'll work on your other items in the next few minutes...

- Moo

[:) Sixthsense :)]

Try this in L2 cell and drag it down
=VLOOKUP($F2,$V$7:$Z$10,MATCH($E2,$V$7:$Z$7,0),0)

Refer the attached file for details.

Hope that helps

[Moo the Dog]

Enter this formula in cell L2 and fill down:

Please Login or Register  to view this content.

- Moo