I have a list of names on column 1 and a list of corresponding numeric values
on column 2. Some of the names appear more than once on the list, but their
values change. The list is a stack which is constantly added to and cannot be
sorted.

I need to find the most bottom cell within the list in which a name appears.
This is required so that I can use VLOOKUP to retrieve its most up-to-date
(lowest on the list) numeric value. The problem with using VLOOKUP for the
task is that it returns the FIRST value it finds in the range and not the
last.

How about the array formula:

=INDEX(B:B,MAX(IF(A1:A16="Wally",ROW(A9:A16))))

commit it by pressing Ctrl-Shift-Enter

this will return the value in column B in the same row where the LAST entry
for Wally appears in column A


"Amit" wrote:

I have a list of names on column 1 and a list of corresponding numeric values
on column 2. Some of the names appear more than once on the list, but their
values change. The list is a stack which is constantly added to and cannot be
sorted.

I need to find the most bottom cell within the list in which a name appears.
This is required so that I can use VLOOKUP to retrieve its most up-to-date
(lowest on the list) numeric value. The problem with using VLOOKUP for the
task is that it returns the FIRST value it finds in the range and not the
last.

=LOOKUP(2,1/(A1:A16="wally"),B1:B16)

On Jan 24, 12:29 pm, Amit wrote:
I have a list of names on column 1 and a list of corresponding numeric values
on column 2. Some of the names appear more than once on the list, but their
values change. The list is a stack which is constantly added to and cannot be
sorted.

I need to find the most bottom cell within the list in which a name appears.
This is required so that I can use VLOOKUP to retrieve its most up-to-date
(lowest on the list) numeric value. The problem with using VLOOKUP for the
task is that it returns the FIRST value it finds in the range and not the
last.