Try this array formula** :

A10 = lookup value

=INDEX(A2:A4,MAX((B2:E4=A10)*ROW(B2:E4))-MIN(ROW(B2:E4))+1)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Eric_G" wrote in message
...
Thanks for your assistance, but not all the values are, in fact, numeric.
Some are text values so the SUMPRODUCT function does not work. Any other
suggestions?

"T. Valko" wrote:

Maybe this...

A10 = 687

=SUMPRODUCT((B2:E4=A10)*A2:A4)

Note this will only work if the table data is unique, In other words,
there
is only one instance of 687 in the table.

--
Biff
Microsoft Excel MVP


"Eric_G" wrote in message
...
I am attempting to look up a particular value in a table and then
identify
the number in the first column of that table which corresponds to that
row.

For example:

111 678 666 475 987
232 565 687 4888 242
4543 123 3334 2727 590

From the above table, be able to enter a value in a formula within a
cell
which in turn, would return the value in the first column of the row
which
contains that value.
For example, if I enter the value 687 in the cell against which the
formula
is applied, I wish the formula to provide the value "232" as the
response.
Similarly, if the value 2727 is entered, the value 4543 should be the
value
response.

Unfortunately, the lookup function doesn't work against a whole table
nor
does it provide a value in the same column.

Suggestions? Many thanks.



.