Returning 2nd and 3rd instances in VLookup

Hi all,

I know this is possible but not sure exactly how I'd do it. I have 250 rows of data and in column A I have various unsorted dates. There will often be 2 or 3 instances of the same date in this column (but never more than 3) and are in random places in the column (not sorted). I need a vlookup formula which can return the value in column B for the 1st instance, the 2nd instance, and the 3rd instance of each date. I don't want to use a VBA code for it and I also can't sort the data by the date in column A. Does anybody know the formula I'd use for this?

Many thanks

Leanne

Leanne

Have a look at the attachment here. There are a few similar examples on the site and doing searches on INDEX and MATCH should bring them back.

You can't use VLOOKUP as it will only return the first appearance.

HTH

rylo