| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and LARGE
I have 8 columns and i need to look in column F1 thru F100 to find the 2nd
most recent date, and then pickup the corresponding number in column G from the same row. I came up with the formula below but it doesn't seem to work. Should it be an "IF" statement instead? OR am I missing something in my formula =VLOOKUP(MAXA('45'!$F$4:$F$100,2),'45'!$G$4:$G$100 ,7,'45'!$G$4:$G$100) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nest vlookup within large function | Excel Worksheet Functions | |||
| VLOOKUP in large Data sets of more than 16384 rows | Excel Worksheet Functions | |||
| vlookup on large text in cells | Excel Worksheet Functions | |||
| Vlookup in large named range | Excel Worksheet Functions | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Threaded Mode
