|Subject:||find value in array on sep sheet & ret correspond val from col lef|
|Date:||Sat, 24 Jun 2006|
I am having difficulty - (maybe just missing an obvious fix)
I need to select a value from another spreadsheet (based on an integer) but
my column with the corresponding integer array is to the right of the array
of information that I want returned.
for example the value on the spread sheet with the formula cell references a
cell (say G3) whose value is 5
spreadsheet that the information is on looks something like this: ( I cannot
change the column with the integer values to be to the left)
I need There a way. do 1
am of has 4 this. 2
in help 2 me 12% 5
dire ! b 2 17 13
I need to write the formula cell to reference G3 (the 5 - this value is an
input) and have it return "in" or "help" or "me"
Hope this gets my point across.
Thanks in advance