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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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.
 
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.
:-)
 
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
 
Yes It DID work - perhaps I am tired as I had an error in my formula
Thanks again SO much!!!!
 
Back
Top