Try this...

Assume the data is in the range A2:C5

E2 = column number = 2
F2 = lookup number = 6

=LOOKUP(2,1/(INDEX(A2:C5,,E2)=F2),ROW(A2:C5)-MIN(ROW(A2:C5))+1)

--
Biff
Microsoft Excel MVP


"engineer" wrote in message
...
I expect the result 3. Hence Max' formula didn't accomplish what I needed
it
to, although close. Can you get me the answer of 3?

Thanks,

"T. Valko" wrote:

Do you want the relative row number or the absolute row number?

Let's assume your sample data is in the range A10:C13. What result do you
expect, 3 or 12?

--
Biff
Microsoft Excel MVP


"engineer" wrote in message
...
I would like to know the row position of a specified column and value in
a
table. If multiple occurences of the specified value occur in a
particular
column, I want the bottom most row position returned. For example, in
the
folowing table, the function would specify column 2 (or B), value of 6,
and
return 3 since the bottom most 6 in column 2 is row 3.

A B C
1 5 8
2 6 9
3 6 10
4 7 11




.