Let's say your example data is in A1:F4. G3 contains the value you want to
match to column F and you want to return the data in column A.

=INDEX(A1:A4,MATCH(G3,F1:F4,0))

Adjust ranges as needed.


"learningasigo" wrote:

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