Excel lookup latest in list

Closed
JayHerring Posts 6 Registration date Friday August 20, 2010 Status Member Last seen September 8, 2010 - Sep 8, 2010 at 06:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 8, 2010 at 06:56 AM
Hello,

Oh what a challenge this is turning into! In a nutshell i would like to lookup the description of a product in a cell, based on the product code in another. Thats the easy bit and a simple vlookup will do here.

The tricky part is that I want to be able to lookup the last Product code entered.

The sheet looks like this (and i can upload an example when i get to a computer later)...

at b2 there is my "description" cell which is where the lookup will take place.

from b4 to b50 there is a set of cells which are where the product codes will go, and what i want is for cell b2 to look for the cell furthest down that is not blank (ie the last code entered), and then look up the product code to find the description on sheet2, columns a (prod code) and column b (description).



1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 8, 2010 at 06:56 AM
try to do this trick

sort the data (with reference to the relevant column) reverse order and use vlookup function.