Thread
:
Lookup the last occurance of a value in a list
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Lookup the last occurance of a value in a list
Did you try it?
--
Don Guillett
SalesAid Software
"Nav" wrote in message
...
Hi
Do you know if this work with text too, or just numbers, as some of the
data
are text.
Thank you.
"Don Guillett" wrote:
One way. This is an ARRAY formula which must be entered using
Ctrl+shift+enter
=INDIRECT("c"&MAX(IF(B1:B10="apple",ROW(A1:A10))))
--
Don Guillett
SalesAid Software
"Nav" wrote in message
...
Hello
I am trying to find out if there is a way or work around to use vlookup
in
a
list where it finds the last occurance of an item and gives the
corresponding
value in relation to it.
Eg.
Pear 5
Apple 5
Orange 3
Plum 2
Apple 1
I need it to look at the last occurance of Apple and return the value
1,
but
the problem is the vlookup finds the first occurance only and returns
5.
Any ideas anyone.
Thank you in advance for any help.
Regards,
Nav
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett