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

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

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

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

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

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

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

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

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

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

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