vlookup duplicate entry help

[Drewbert34]

Okay, I have a confusing one for me. I need to perform a vlookup off column A (Store). I need it to always return the last entry. Because duplicate entries in this column are commonplace I need to find a way to differentiate which one I want to reference. In this case I want to do so with the date of entry column...is this possible with a date?...if so how?

<TABLE style="WIDTH: 146pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=194><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><TBODY><TR style="HEIGHT: 90pt" height=120><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; WIDTH: 77pt; HEIGHT: 90pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl433 height=120 width=102>Store</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 69pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl447 width=92>Date of Entry</TD></TR><TR style="HEIGHT: 38.25pt" height=51><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 77pt; FONT-FAMILY: Arial; BACKGROUND: #bfbfbf; HEIGHT: 38.25pt; COLOR: #9c0006; FONT-SIZE: 12pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl434 height=51 width=102>6771</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 69pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl443 width=92>N/A</TD></TR><TR style="HEIGHT: 38.25pt" height=51><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 77pt; FONT-FAMILY: Arial; BACKGROUND: #bfbfbf; HEIGHT: 38.25pt; COLOR: #9c0006; FONT-SIZE: 12pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl434 height=51 width=102>6771</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 69pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl450 width=92>8/9/11</TD></TR></TBODY></TABLE>

 

[ppleasebob]

Hi,

Could you get round this by sorting the columns? i.e. sort column A in ascending order, and then column b in descending. This should put the 'latest' occurrence of the number in column A and therefore will be the first result the lookup finds?

bob

 

[Drewbert34]

Hi,

Could you get round this by sorting the columns? i.e. sort column A in ascending order, and then column b in descending. This should put the 'latest' occurrence of the number in column A and therefore will be the first result the lookup finds?

bob

Hello Bob, thanks for your reply!

No unfortunately the most recent entry has to to stay to the bottom due to work requirements.

 

[Drewbert34]

Hello Bob, thanks for your reply!

No unfortunately the most recent entry has to to stay to the bottom due to work requirements.

Following up:

Instead of doing a vlookup off a live copy of the doccument I saved a copy strictly for other doccuments to reference...in which case this simple solution works wonderfully!

Thank You!