The terror of advancing cell numbers!

S

Sivodsi

Thanks for the advice!

I was actually using $ but like this:

=VLOOKUP($A2,'South Africa 2004 Results'!$A1:$J344,4,FALSE)

It did not stop it from advancing the cell numbers with every post tha
I did.
I can see now that it is different from the form posted, so that'
where I was mucking up. Strange though, that it didn't give me problem
before.

I'm looking forward to trying the range numbers solution, since thi
would make easier a number of things that I often do.

Thanks once more for the help
Davi
 
Top