tlc53
Active Member
- Joined
- Jul 26, 2018
- Messages
- 399
Hi,
I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve;
Car Type
B14:B23
Tax Treatment
E14:E23
Private %
F14:F23
Input Data
B28:B37
I would like the Input Data B28:B37 to be pre-populated depending on what the Tax Treatment and Private % are.
So if Tax Treatment = "Private Portion" AND Private % <.75 then populate Input Data with Car Type.
Eg. E14 = "Private Portion AND F14 <.75 then B28 = B14.
So all entries meeting this criteria will be shown in cells B28:B37 but with no duplications.
Hope I've explained that clearly enough! Thank you
I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve;
Car Type
B14:B23
Tax Treatment
E14:E23
Private %
F14:F23
Input Data
B28:B37
I would like the Input Data B28:B37 to be pre-populated depending on what the Tax Treatment and Private % are.
So if Tax Treatment = "Private Portion" AND Private % <.75 then populate Input Data with Car Type.
Eg. E14 = "Private Portion AND F14 <.75 then B28 = B14.
So all entries meeting this criteria will be shown in cells B28:B37 but with no duplications.
Hope I've explained that clearly enough! Thank you
