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

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

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

Great!!!
Thank You SO much,
I have been messing with that off and on all evening. I had tried the
match and the index and the vlookup (but columns were backwards); I had even
tried nesting but just couldn't seem to get it.

Thanks again now I can retire for the evening.
:-)

"JMB" wrote:

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

Okay I was wrong it did not work it pulled the corresponding row value. It
pulled the 5th item in column A. Not the information that corresponds to 5
in column A
should have pulled "in"
close but...
bummer



"JMB" wrote:

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

Yes It DID work - perhaps I am tired as I had an error in my formula
Thanks again SO much!!!!

"learningasigo" wrote:

> Okay I was wrong it did not work it pulled the corresponding row value. It
> pulled the 5th item in column A. Not the information that corresponds to 5
> in column A
> should have pulled "in"
> close but...
> bummer
>
>
>
> "JMB" wrote:
>
> > 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
> > >
> > >
> > >

I'm glad that worked for you.

"learningasigo" wrote:

> Yes It DID work - perhaps I am tired as I had an error in my formula
> Thanks again SO much!!!!
>
> "learningasigo" wrote:
>
> > Okay I was wrong it did not work it pulled the corresponding row value. It
> > pulled the 5th item in column A. Not the information that corresponds to 5
> > in column A
> > should have pulled "in"
> > close but...
> > bummer
> >
> >
> >
> > "JMB" wrote:
> >
> > > 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
> > > >
> > > >
> > > >