find value in array on sep sheet & ret correspond val from col lef

Giganews Newsgroups
Subject: find value in array on sep sheet & ret correspond val from col lef
Posted by:  learningasigo
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

Replies