View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Moon Mike Moon is offline
external usenet poster
 
Posts: 1
Default 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).