software

I am trying to do a simple lookup in one range of cells that contain numbers
1-9 and return a result from the cell that is next to it.

Hi!

Assume your lookup value is in A1.

Your 2 column table is in the range A10:B18.

A1 = 7

=IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,A10:B18,2,0))

Biff

quot;whub3quot; gt; wrote in message
...
gt;I am trying to do a simple lookup in one range of cells that contain
gt;numbers
gt; 1-9 and return a result from the cell that is next to it.
OK. That gave me the value I was searching for, but I want to return the an
adjacent value.
I have two columns, one with text and one with numerals. In a different cell
in the same worksheet I want to search the numerical column for a particular
number (like 1) and return the name (like Dave) that is adjacent (just to the
left) of the cell with the number from the number column.

Thanks!

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Assume your lookup value is in A1.
gt;
gt; Your 2 column table is in the range A10:B18.
gt;
gt; A1 = 7
gt;
gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,A10:B18,2,0))
gt;
gt; Biff
gt;
gt; quot;whub3quot; gt; wrote in message
gt; ...
gt; gt;I am trying to do a simple lookup in one range of cells that contain
gt; gt;numbers
gt; gt; 1-9 and return a result from the cell that is next to it.
gt;
gt;
gt;

If you need to return something to the left of your lookup range, then you
will need to use something like index/match instead of vlookup. Try this one:

=IF(A1 = quot;quot;, quot;quot;, INDEX($A$10:$A$18, MATCH(A1,$B$10:$B$18,0)))

--
Kevin Vaughnquot;whub3quot; wrote:

gt; OK. That gave me the value I was searching for, but I want to return the an
gt; adjacent value.
gt; I have two columns, one with text and one with numerals. In a different cell
gt; in the same worksheet I want to search the numerical column for a particular
gt; number (like 1) and return the name (like Dave) that is adjacent (just to the
gt; left) of the cell with the number from the number column.
gt;
gt; Thanks!
gt;
gt; quot;Biffquot; wrote:
gt;
gt; gt; Hi!
gt; gt;
gt; gt; Assume your lookup value is in A1.
gt; gt;
gt; gt; Your 2 column table is in the range A10:B18.
gt; gt;
gt; gt; A1 = 7
gt; gt;
gt; gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,A10:B18,2,0))
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;whub3quot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I am trying to do a simple lookup in one range of cells that contain
gt; gt; gt;numbers
gt; gt; gt; 1-9 and return a result from the cell that is next to it.
gt; gt;
gt; gt;
gt; gt;

Kevin,

Thank you. That answered my question

quot;Kevin Vaughnquot; wrote:

gt; If you need to return something to the left of your lookup range, then you
gt; will need to use something like index/match instead of vlookup. Try this one:
gt;
gt; =IF(A1 = quot;quot;, quot;quot;, INDEX($A$10:$A$18, MATCH(A1,$B$10:$B$18,0)))
gt;
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;whub3quot; wrote:
gt;
gt; gt; OK. That gave me the value I was searching for, but I want to return the an
gt; gt; adjacent value.
gt; gt; I have two columns, one with text and one with numerals. In a different cell
gt; gt; in the same worksheet I want to search the numerical column for a particular
gt; gt; number (like 1) and return the name (like Dave) that is adjacent (just to the
gt; gt; left) of the cell with the number from the number column.
gt; gt;
gt; gt; Thanks!
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt; gt; Hi!
gt; gt; gt;
gt; gt; gt; Assume your lookup value is in A1.
gt; gt; gt;
gt; gt; gt; Your 2 column table is in the range A10:B18.
gt; gt; gt;
gt; gt; gt; A1 = 7
gt; gt; gt;
gt; gt; gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,A10:B18,2,0))
gt; gt; gt;
gt; gt; gt; Biff
gt; gt; gt;
gt; gt; gt; quot;whub3quot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I am trying to do a simple lookup in one range of cells that contain
gt; gt; gt; gt;numbers
gt; gt; gt; gt; 1-9 and return a result from the cell that is next to it.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

You're welcome.
--
Kevin Vaughnquot;whub3quot; wrote:

gt; Kevin,
gt;
gt; Thank you. That answered my question
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; If you need to return something to the left of your lookup range, then you
gt; gt; will need to use something like index/match instead of vlookup. Try this one:
gt; gt;
gt; gt; =IF(A1 = quot;quot;, quot;quot;, INDEX($A$10:$A$18, MATCH(A1,$B$10:$B$18,0)))
gt; gt;
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;whub3quot; wrote:
gt; gt;
gt; gt; gt; OK. That gave me the value I was searching for, but I want to return the an
gt; gt; gt; adjacent value.
gt; gt; gt; I have two columns, one with text and one with numerals. In a different cell
gt; gt; gt; in the same worksheet I want to search the numerical column for a particular
gt; gt; gt; number (like 1) and return the name (like Dave) that is adjacent (just to the
gt; gt; gt; left) of the cell with the number from the number column.
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt; gt;
gt; gt; gt; quot;Biffquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi!
gt; gt; gt; gt;
gt; gt; gt; gt; Assume your lookup value is in A1.
gt; gt; gt; gt;
gt; gt; gt; gt; Your 2 column table is in the range A10:B18.
gt; gt; gt; gt;
gt; gt; gt; gt; A1 = 7
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,A10:B18,2,0))
gt; gt; gt; gt;
gt; gt; gt; gt; Biff
gt; gt; gt; gt;
gt; gt; gt; gt; quot;whub3quot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I am trying to do a simple lookup in one range of cells that contain
gt; gt; gt; gt; gt;numbers
gt; gt; gt; gt; gt; 1-9 and return a result from the cell that is next to it.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;