Vlookup Last Item

les.price

How can I lookup the last instance of an item in a range as opposed to the first, as with vlookup,falce? I have tried index and match (2,1***etc) with no success?

Thanks

Paul Newcome

Can you provide a screenshot with some mock data manually entered to show exactly what you are trying to accomplish?

L_123

=index(collect(),count(collect()))

is the basic outline of how you can do this. both collect formulas will be the same, you can just copy paste them