BabyFish2019
New Member
- Joined
- Nov 25, 2019
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hi
I am looking to create an array to help schedule resourcing but it needs to somehow I think include an IF statement as well but I cant work out how to do it. The formula I have at present is this
The data in column A is what looks up against the assumptions table and will then return columns 3,4,and 5 from that in columns C,D and E
So say columns 3, 4 and 5 say Product1, Product 2 and Product 3 my formula below will return the following
(VLOOKUP($A$2,'Assumption Tables'!$A$8:$AC$12,{3,4,5},FALSE))
What I want to do is add in a second variable which is in cell B2. So if row 1 matches column B2 then it will perform the array formula. If I were to change the date in column B like I have in Row 3 then the data shows in Apr 20 etc
I am looking to create an array to help schedule resourcing but it needs to somehow I think include an IF statement as well but I cant work out how to do it. The formula I have at present is this
The data in column A is what looks up against the assumptions table and will then return columns 3,4,and 5 from that in columns C,D and E
So say columns 3, 4 and 5 say Product1, Product 2 and Product 3 my formula below will return the following
(VLOOKUP($A$2,'Assumption Tables'!$A$8:$AC$12,{3,4,5},FALSE))
Feb 20 | Mar 20 | Apr 20 | May 20 | June 20 | July 20 | ||
Small | May 20 | Product 1 | Product 2 | Product 3 |
What I want to do is add in a second variable which is in cell B2. So if row 1 matches column B2 then it will perform the array formula. If I were to change the date in column B like I have in Row 3 then the data shows in Apr 20 etc
Feb 20 | Mar 20 | Apr 20 | May 20 | June 20 | July 20 | ||||
Small | May 20 | Product 1 | Product 2 | Product 3 | |||||
Small | Apr 20 | Product 1 | Product 2 | Product 3 |