Budge
2017-07-21 10:32:59 UTC
I am using a formula to fill in a cell. The formula is in cell J2
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table and enters it into cell J2.
I want to repeat this formula down the column J but when I copy, not
only does the reference cell change ie E2 becomes E3 which is correct,
but the table cell definition also changes, which is not correct.
How should I write the formula to have the table fixed whilst lookup
cell changes please?
Budgie
=VLOOKUP(E2,Sheet2.A2:B690,2,0).
This is looks up the value from E2 in the column 1 of the table on sheet
2 defined by corners A2:B690, takes the corresponding value from column
2 of the table and enters it into cell J2.
I want to repeat this formula down the column J but when I copy, not
only does the reference cell change ie E2 becomes E3 which is correct,
but the table cell definition also changes, which is not correct.
How should I write the formula to have the table fixed whilst lookup
cell changes please?
Budgie
--
To unsubscribe e-mail to: users+***@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 t
To unsubscribe e-mail to: users+***@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 t