Hi all,
I usually post my words of wisdom and cries for help to the main Win 9x board, but hope I am in the correct place here to ask the following question:
I use Windows 98SE running Office Professional XP (which you will know does not require the XP OS).
I have 2 sheets in an excel file. One called "fans" (with columns of names and email addresses) the other called "cobra" (with just names of fans from my other database).
On the FANS sheet, I need to check whether the person I've just entered isn't already on the COBRA sheet, so in, say, field D1 I have the function
=LOOKUP(B1;Cobra!A1:A963)
Meaning: Look up the name in field B1 and compare it to any name in the COBRA sheet, rows 1 to 963.
If it finds the name, it automatically enters TRUE, otherwise it enters FALSE.
With my old Office Professional 97, I would just make sure that D2, D3, D4 held a similar function
=LOOKUP(B2;Cobra!A1:A963)
=LOOKUP(B3;Cobra!A1:A963)
=LOOKUP(B4;Cobra!A1:A963)
then mark these and use the handle marker to pull them all the way down to the bottom of the list, and it would only change the reference to "B". (A1:A963 would always stay the same). Now it changes everything.
In row 6 for example I get
=LOOKUP(B6;Cobra!A6:A969)
etc. which is wrong.
No matter how I set the settings in
Tools -> Edit, and no matter how lines I "pre-set" (even down to row 10 using
=LOOKUP(B10;Cobra!A1:A963)
it still changes the reference row numbers of the COBRA sheet.
Any ideas how I can stop it doing this ? It should only change the B reference and nothing else.
Many thanks for any hints or tips.
Dane
|
