Can you use the match function to return the last match instead of the first?
I know the match type 0 returns the first exact match. I tried using the
match type number that was the same as the quantity of entries to return the
last exact match, but I get an error. Does match type only accept -1, 0, and
1??
--
Shirley

Hi!

Try this:

.............A............B
1........Tom.........20
2........Joe...........55
3........Sue...........70
4........Tom..........10

C1 = lookup value = Tom

=LOOKUP(2,1/(A1:A4=C1),B1:B4)

Returns 10

Biff

"Shirley" wrote in message
...
Can you use the match function to return the last match instead of the
first?
I know the match type 0 returns the first exact match. I tried using the
match type number that was the same as the quantity of entries to return
the
last exact match, but I get an error. Does match type only accept -1, 0,
and
1??
--
Shirley

Thank You, I will try that this morning instead of Index.

--
Shirley


"Biff" wrote:

Hi!

Try this:

.............A............B
1........Tom.........20
2........Joe...........55
3........Sue...........70
4........Tom..........10

C1 = lookup value = Tom

=LOOKUP(2,1/(A1:A4=C1),B1:B4)

Returns 10

Biff

"Shirley" wrote in message
...
Can you use the match function to return the last match instead of the
first?
I know the match type 0 returns the first exact match. I tried using the
match type number that was the same as the quantity of entries to return
the
last exact match, but I get an error. Does match type only accept -1, 0,
and
1??
--
Shirley

You're welcome!

Biff

"Shirley" wrote in message
...
Thank You, I will try that this morning instead of Index.

--
Shirley


"Biff" wrote:

Hi!

Try this:

.............A............B
1........Tom.........20
2........Joe...........55
3........Sue...........70
4........Tom..........10

C1 = lookup value = Tom

=LOOKUP(2,1/(A1:A4=C1),B1:B4)

Returns 10

Biff

"Shirley" wrote in message
...
Can you use the match function to return the last match instead of the
first?
I know the match type 0 returns the first exact match. I tried using
the
match type number that was the same as the quantity of entries to
return
the
last exact match, but I get an error. Does match type only accept -1,
0,
and
1??
--
Shirley