#1
|
|||
|
|||
Help create this formula:
Hello guys, Hope everyone is fine and this virus get off soon! Now basically i need to create a formula that has as main core VLOOKUP (i think so...) All the instruction about what i need are included in the excel file i sended attached. Please i cant make this work as i want... Thnak you in advace! |
#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 |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
OK, if you are changing the Month in E2 and want the calculation in D2 then put this formula in D2
Code:
=IF(COUNTIFS(OFFSET(G1,1,MATCH(E2,H1:L1,0),21,2),B3)>0,"Yes","No")
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
Quote:
WORKS PERFECT!!!! Thank you! Last edited by andysvision; 05-02-2020 at 11:28 AM. |
Tags |
excel formula, formula |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a simple formula | ep2002 | Excel | 1 | 09-06-2017 11:00 PM |
Help to create this formula: | andysvision | Excel | 7 | 01-05-2017 02:35 PM |
How to create mileage formula | maxliv | Excel | 4 | 08-15-2016 08:13 AM |
Create formula for entire column | tdodson | Excel | 2 | 10-27-2015 09:38 PM |
Please help me create this formula... | doublejoy | Excel | 1 | 08-22-2009 03:04 AM |