Hi,
I'm trying to figure out how to use a Match Index for my example below.
I've got a list of all the dates where fruit were sold. They're all unique and there are no duplicates. I've then arranged them in a column (under date) and want to the fruit that was sold on that date to appear in the column "What fruit?".
Would anyone have an idea of how to do this? It seems like it should be easy but can't find an answer anywhere!
Cheers
Product Sold on Sold on2 Sold on3 Sold on4 Sold on5
Apples 01-Jan 01-May 07-Jun
Pears 04-Jan 02-Feb
Bananas 05-Apr 10-Dec 11-Nov 09-Sep 07-Jul
Date What fruit?
01-Jan #N/A
04-Jan #N/A
05-Apr #N/A
01-May #N/A
02-Feb #N/A
10-Dec #N/A
07-Jun #N/A
11-Nov #N/A
09-Sep #N/A
07-Jul #N/A
Bookmarks