repost from general area ref values with column to left HELP
 

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

The 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
*** !! ++ ## -- 17

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"

Thanks JMB I thougth you gave me the correct solution with
=INDEX(A1:A4,MATCH(G3,F1:F4,0))
but it gave me the index of the value so if the value in G3 was 5
it gave me "***" (I had to add to my original example to include a 5th row
of info to display the example)

Because I am accessing between 2 sheets my formula actually looked more like
=INDEX('info sheet'!A1:A10,MATCH(G3,'info sheet'!F1:F10))

(the G3 cell and the formula cell are on one sheet and the other sheet has
the information I want to pull from - and I CANNOT change that information or
the way it is formatted)

Sorry this is so long but ...
Hope this gets my point across.
Thanks in advance

repost from general area ref values with column to left HELP
 

The solution JMB did work -
I had an input error in my formula -
Thanks again

"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

The 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
*** !! ++ ## -- 17

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"

Thanks JMB I thougth you gave me the correct solution with
=INDEX(A1:A4,MATCH(G3,F1:F4,0))
but it gave me the index of the value so if the value in G3 was 5
it gave me "***" (I had to add to my original example to include a 5th row
of info to display the example)

Because I am accessing between 2 sheets my formula actually looked more like
=INDEX('info sheet'!A1:A10,MATCH(G3,'info sheet'!F1:F10))

(the G3 cell and the formula cell are on one sheet and the other sheet has
the information I want to pull from - and I CANNOT change that information or
the way it is formatted)

Sorry this is so long but ...
Hope this gets my point across.
Thanks in advance