[libreoffice-users] Help with VLOOKUP requested

I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills 
in J2 with the value corresponding to the number in E2 which is looked 
up from a table in sheet2.

My problem is that when I copy this formula down column J the E2 changes 
to E3 which is correct, but the table defined by Sheet2.A2:B690, which 
should be fixed, has the addresses changed also.

How may I fix the lookup table when I copy the file down a column please?

---
This email has been checked for viruses by AVG.
http://www.avg.com


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted