repost from general area ref values with column to left HELP

[Guest]

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

 

[Guest]

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