S
shannoncox
Hi
I have one spreadsheet saved as a file that is intended to be a look up
table. 'Column A' is an index column with cells having the numbers 1 to
250 in ascending order. 'Column B' is a column that contains strings 1
to 250.
I'd like to create ANOTHER spreadsheet so that when I entered a number,
1 to 250, in a cell, it would call up the string adjacent to that number
in the lookup table spreadsheet.
Hope this makes sense... Any ideas on how to achieve this?
Shannon
I have one spreadsheet saved as a file that is intended to be a look up
table. 'Column A' is an index column with cells having the numbers 1 to
250 in ascending order. 'Column B' is a column that contains strings 1
to 250.
I'd like to create ANOTHER spreadsheet so that when I entered a number,
1 to 250, in a cell, it would call up the string adjacent to that number
in the lookup table spreadsheet.
Hope this makes sense... Any ideas on how to achieve this?
Shannon