Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to get a function that will allow me to pull up multiple entries
from a single vlookup (or multiple lookups perhaps that would pull sequential records) So lets say I have a worksheet with: A B C Date Name Invoice Number I need the last 5 invoices from name X to display on another worksheet in seperate cells. Ideas? I've tried the User Defined vlookups tool I found online and couldn't get it to work (and yes I've Cntrl-Shift enter to make it an array). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The sum of multiple returns on a vlookup | Excel Worksheet Functions | |||
add multiple returns using vlookup | Excel Worksheet Functions | |||
VLOOKUP - MULTIPLE RETURNS | Excel Worksheet Functions | |||
Vlookup with multiple returns | Excel Worksheet Functions | |||
Vlookup Multiple Returns #REF | Excel Discussion (Misc queries) |