Look in the help index for MATCH

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

The Match function requires you to specify a range. I am only wanting to
specify the column number.

"Don Guillett" wrote:

Look in the help index for MATCH

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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



.

As posted in the other branch, one way to engineer it ...
----------------
In E1: 2 (input the col number, eg col B = 2)
In E2: 6 (input the value in col B to be found)
Then in E3, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula:
=MAX(IF(OFFSET(A1:A4,,E1-1)=E2,ROW(A1:A4)))
Success? celebrate it, hit the YES below
--
Max
Singapore
---

I still don't understand why match won't get what you want??
=MATCH(6,F:F)
or if 2 (col B) in e1 and 6 in e2 and range sorted. Others better but..
=MATCH(E2,INDIRECT(""&LEFT(ADDRESS(1,E1,4),FIND(1, ADDRESS(1,E1,4))-1)&":"&LEFT(ADDRESS(1,E1,4),FIND(1,ADDRESS(1,E1,4) )-1)&""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"engineer" wrote in message
...
The Match function requires you to specify a range. I am only wanting to
specify the column number.

"Don Guillett" wrote:

Look in the help index for MATCH

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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



.