software

It is probably better to explain what I am trying to do rather than show
the INDEX, MATCH and other permutations I have been trying and failing
miserably with. I have for example two columns of Data A amp; B. The values
in column B are unique so are no repeated anywhere else in the column.
If I have a value in cell D1 for example, say 31, I want to find that
value in Column B, if it exists, then return the value in Column A in
the same row. I hope this is understandable and if so I would be really
grateful for any ideas.

Regards
Graham Haughs
Turriff
Scotland

=index(a:a,match(d1,b:b,0))

You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html (for =vlookup())
and
www.contextures.com/xlFunctions03.html (for =index(match()))

Graham Haughs wrote:
gt;
gt; It is probably better to explain what I am trying to do rather than show
gt; the INDEX, MATCH and other permutations I have been trying and failing
gt; miserably with. I have for example two columns of Data A amp; B. The values
gt; in column B are unique so are no repeated anywhere else in the column.
gt; If I have a value in cell D1 for example, say 31, I want to find that
gt; value in Column B, if it exists, then return the value in Column A in
gt; the same row. I hope this is understandable and if so I would be really
gt; grateful for any ideas.
gt;
gt; Regards
gt; Graham Haughs
gt; Turriff
gt; Scotland

--

Dave Peterson


=IF(ISNA(MATCH(D1,B:B,0)),quot;quot;,INDEX(A:A,MATCH(D1,B: B,0)))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Graham Haughsquot; gt; wrote in message
...
gt; It is probably better to explain what I am trying to do rather than show
gt; the INDEX, MATCH and other permutations I have been trying and failing
gt; miserably with. I have for example two columns of Data A amp; B. The values
gt; in column B are unique so are no repeated anywhere else in the column.
gt; If I have a value in cell D1 for example, say 31, I want to find that
gt; value in Column B, if it exists, then return the value in Column A in
gt; the same row. I hope this is understandable and if so I would be really
gt; grateful for any ideas.
gt;
gt; Regards
gt; Graham Haughs
gt; Turriff
gt; Scotland
Thanks to both for really helpful replies and links.

Graham

Dave Peterson wrote:
gt; =index(a:a,match(d1,b:b,0))
gt;
gt; You may want to read Debra Dalgleish's notes:
gt; www.contextures.com/xlFunctions02.html (for =vlookup())
gt; and
gt; www.contextures.com/xlFunctions03.html (for =index(match()))
gt;
gt; Graham Haughs wrote:
gt;
gt;gt;It is probably better to explain what I am trying to do rather than show
gt;gt;the INDEX, MATCH and other permutations I have been trying and failing
gt;gt;miserably with. I have for example two columns of Data A amp; B. The values
gt;gt;in column B are unique so are no repeated anywhere else in the column.
gt;gt;If I have a value in cell D1 for example, say 31, I want to find that
gt;gt;value in Column B, if it exists, then return the value in Column A in
gt;gt;the same row. I hope this is understandable and if so I would be really
gt;gt;grateful for any ideas.
gt;gt;
gt;gt;Regards
gt;gt;Graham Haughs
gt;gt;Turriff
gt;gt;Scotland
gt;
gt;