imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
Excel keeps saying "circular reference." I don't understand why!!! pls help.
On 2002-10-03 15:10, watercolor wrote:
Excel keeps saying "circular reference." I don't understand why!!! pls help.
On 2002-10-03 15:14, Mark O'Brien wrote:
Post your VLOOKUP formula. It sounds like you're telling Excel to lookup a value in a range, but are using one of the values in the range as the search criteria.
On 2002-10-03 15:14, Mark O'Brien wrote:
Post your VLOOKUP formula. It sounds like you're telling Excel to lookup a value in a range, but are using one of the values in the range as the search criteria.
used the VLookup function: a3, sheet2!a3:h13, false ]
On 2002-10-03 15:14, Aladin Akyurek wrote:
On 2002-10-03 15:10, watercolor wrote:
Excel keeps saying "circular reference." I don't understand why!!! pls help.
Care to post the VLOOKUP formula that you are trying to use.
[used VLOOKUP function: a3, sheet2!a3:h13, 6, false. i really don't understand the use of this function - new to Excel - was a homework assignment]
On 2002-10-03 15:14, Aladin Akyurek wrote:
On 2002-10-03 15:10, watercolor wrote:
Excel keeps saying "circular reference." I don't understand why!!! pls help.
Care to post the VLOOKUP formula that you are trying to use.
[used VLOOKUP function: a3, sheet2!a3:h13, 6, false. new to Excel]
On 2002-10-03 15:50, watercolor wrote:
On 2002-10-03 15:14, Aladin Akyurek wrote:
On 2002-10-03 15:10, watercolor wrote:
Excel keeps saying "circular reference." I don't understand why!!! pls help.
Care to post the VLOOKUP formula that you are trying to use.
[used VLOOKUP function: a3, sheet2!a3:h13, 6, false. i really don't understand the use of this function - new to Excel - was a homework assignment]
Homework assignment... Hmmm.
Did you enter in A3 in Sheet2 something like:
=VLOOKUP(A3,Sheet2!A3:H13,6,FALSE) ?
What do you have in A3 and in Sheet2!A3:H13?