Luis,

In A2, array enter (enter using Ctrl-Shift-Enter) the formula

=MIN(IF(OFFSET($F$1,MAX((A3:A10000=A1)*ROW(A3:A100 00))-1,0,10000,1)="",
ROW(OFFSET($F$1,MAX((A3:A10000=A1)*ROW(A3:A10000))-1,0,10000,1)),10001))-1

HTH,
Bernie
MS Excel MVP


"LuisE" wrote in message
...
Bernie,
Thanks again for your help and patience.

Let's say that te following ranges hold my data

"A50" "B50:F60"
"A63" "B63:F80"
"A100" "B100:F135"

In "A1" I have a validation list with the contents of ColA (it works just
fine)
In "A2" I have a formula that returns the row number (in"A50:A100") of
the
selected value in A1. It works just fine.

In "A3" I need a formula to return the last row in ColF associated to the
selectd value in A1. ie:

if A1 show the value of A50 then A2=50 A3=60
if A1 show the value of A63 then A2=63 A3=80
if A1 show the value of A100 then A2=100 A3=135