ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Multiple returns from vlookup (https://www.excelbanter.com/excel-worksheet-functions/238619-multiple-returns-vlookup.html)

Mike Moon

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