Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedded vlookup question
I have a vlookup that isn't working because it would pull back multiple
rows. How do I tell the vlookup to pull back the row with the most recent date? Example of existing query: =VLOOKUP($A$22,'Tgt Inv'!$B:$F,4,FALSE) Will pull back following rows since they all have 302 as the delimiter. NA 302 2/14/2006 340 670 4.6 NA 302 1/18/2006 304 670 4 NA 302 12/18/2005 340 670 4.3 NA 302 1/26/2004 340 670 4 How do I embedd something in it to pull the row with the latest date-- or in this example-- the one with the 2/14/06 date? Help? Thanks! knox5731 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP function with embedded LEFT | Excel Worksheet Functions | |||
Symbols showing up as question (?) in embedded excel table in word | Excel Discussion (Misc queries) | |||
Embedded vlookup? | Excel Worksheet Functions | |||
Embedded excel sheet in outlook question??? | Excel Discussion (Misc queries) | |||
question about scrollbars and embedded charts | Excel Programming |