repost from general area ref values with column to left HELP

[learningasigo]

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

[learningasigo]

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
>
>
>