Google Sheet vlookup from bottom up

Hi,

I have searched around the forum, but the solutions did not work for me.

I have item IDs in column A and in another sheet (Sheet1) i have Item IDs and their dated repricing entry in Sheet1. I want to lookup the last repricing date which would be identified by looking up from bottom to top of Sheet1.


=LOOKUP(2,1/(A2:A=Sheet1!M2:M),Sheet1!N2:N)

A2:A - has all the Item IDs

Sheet1!M2:M - has all the item IDs on Sheet1
Sheet1!N2:N - has all the dates

But, when i use this formula i am not getting all the dates from bottom up, getting strange results actually.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.