![]() |
Multiple returns from vlookup
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). |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com