Lookup Functino

Hey guys,
complete rookie here, trying to learn some stuff for university about the basics of excel.


I attached a sample part of the document im working on, i have ranked the total sales of specific sale ids, all i wish to find are the bottom 5 sales, i tried using a hlookup function but was unable to do so, my theory which did not work was to look up 1 and find the product ID which was above it, i kept getting N/A. Any help, hints, or if anyone could show me how and upload a completed one? that would be awesome. All im trying to do is transfer the ranked items to the first page, so it says A1: Ranked 1, B1: PRODUCTID
that kind of thing,

THANKYOU ALL,

Move the Ranks in Row 3 above the Product Codes in Row 2. Then the hlookup will work on Sheet1.

or use this formula

Please Login or Register  to view this content.