Start VLOOKUP at the bottom????

[CHC Consulting LLC]

=IF(A2>0,VLOOKUP($AB2,'EVERYDAY LOG'!A:H,4,FALSE),"")

I need to modify this formula to return the value that is the furthest down the sheet if it finds duplicates.

Is it possible to have the vlookup start its lookup at the bottom of a sheet?

 

[Ganjin]

=IF(A2>0,VLOOKUP($AB2,OFFSET('EveryDay Log'!$A$1,COUNTIF('EveryDay Log'!A:A,$AB2)-1,0):'EveryDay Log'!H1000,4,0),"")

 

[CHC Consulting LLC]

Thank You!!!

 

[CHC Consulting LLC]

=IF(A2>0,VLOOKUP($AB2,OFFSET('EveryDay Log'!$A$1,COUNTIF('EveryDay Log'!A:A,$AB2)-1,0):'EveryDay Log'!H1000,4,0),"")

It is still returning the first value it sees??? Any ideas?

 

[Ganjin]

ah, my apologies, I didn't think that one through
brb

 

[Boller]

<TABLE style="WIDTH: 422pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=563><COLGROUP><COL style="WIDTH: 422pt; mso-width-source: userset; mso-width-alt: 20589" width=563><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 422pt; HEIGHT: 25.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=34 rowSpan=2 width=563>=IF(A2>0,LOOKUP(2,1/('EVERYDAY LOG'!A:A=$AB2),'EVERYDAY LOG'!H:H),"")</TD></TR><TR style="HEIGHT: 12.75pt" height=17></TR></TBODY></TABLE>

 

[CHC Consulting LLC]

<table style="width: 422pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="563"><colgroup><col style="width: 422pt;" width="563"></colgroup><tbody><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; width: 422pt; height: 25.5pt;" class="xl64" rowspan="2" height="34" width="563">=IF(A2>0,LOOKUP(2,1/('EVERYDAY LOG'!A:A=$AB2),'EVERYDAY LOG'!H:H),"")</td></tr><tr style="height: 12.75pt;" height="17"></tr></tbody></table>

This is returning blanks? Do I need to modify something before using it in my sheet?

 

[Ganjin]

=IF(A2>0,VLOOKUP($AB2,OFFSET('EveryDay Log'!$A$1,LARGE(ROW('EveryDay Log'!$A$1:$A$1000)*('EveryDay Log'!$A$1:$A$1000=$AB2),1)-1,0):'EveryDay Log'!$H$1000,4,0),"")
Ctrl+Shift+Enter

 

[CHC Consulting LLC]

=IF(A2>0,VLOOKUP($AB2,OFFSET('EveryDay Log'!$A$1,LARGE(ROW('EveryDay Log'!$A$1:$A$1000)*('EveryDay Log'!$A$1:$A$1000=$AB2),1)-1,0):'EveryDay Log'!$H$1000,4,0),"")
Ctrl+Shift+Enter

Worked! Thank you!!!!

 

[Boller]

This is returning blanks? Do I need to modify something before using it in my sheet?

It works for me.