![]() |
#2
|
||||
|
||||
![]()
This is harder than it needs to be because your source data is not one list and so you would need to nest different formulas for each month. Also, you haven't specified what happens when a fruit appears in more than one month.
I suggest you reformat your three lists to make a two column table like this Fruit | Month Apple | March Fig | March You will then find that VLookup becomes a lot easier and you can use a pivot table if you want to display the data like the way you presented it in your sample. I would also recommend you learn about Index and Match from resources you can find online like this one
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
excel formula, formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a simple formula | ep2002 | Excel | 1 | 09-06-2017 11:00 PM |
![]() |
andysvision | Excel | 7 | 01-05-2017 02:35 PM |
![]() |
maxliv | Excel | 4 | 08-15-2016 08:13 AM |
![]() |
tdodson | Excel | 2 | 10-27-2015 09:38 PM |
Please help me create this formula... | doublejoy | Excel | 1 | 08-22-2009 03:04 AM |