LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hi Fellow Excel Peps...
I am stuck once again and would really appreciate your help.
I have 6 values in the following cells:
(Clean net) I3
(Clean gross) J3
(Average net) I4
(Average gross) J4
(Below net) I5
(Below gross) J5.
I have 2 dropdown boxes which both have 2-3 options each:
Dropdown 1 in A3 = "Car" or "Van"
Dropdown 2 in A4 = "Repaired", "Repair date known" or "Repair to be scheduled"
I want my formula in F11 to determine which value (J3, J4 or J4) to pick based on the dropdown criteria:
Car
Repaired
= J3
Car
Repair date known
= J3
Car
Repair to be scheduled
= J4
Van
Repaired
= I4
Van
Repair date known
= I4
Van
Repair to be scheduled
= I5
Thanks so much for your help with this, it's really been struggling with this one.
Thank you
Lauren
I am stuck once again and would really appreciate your help.
I have 6 values in the following cells:
(Clean net) I3
(Clean gross) J3
(Average net) I4
(Average gross) J4
(Below net) I5
(Below gross) J5.
I have 2 dropdown boxes which both have 2-3 options each:
Dropdown 1 in A3 = "Car" or "Van"
Dropdown 2 in A4 = "Repaired", "Repair date known" or "Repair to be scheduled"
I want my formula in F11 to determine which value (J3, J4 or J4) to pick based on the dropdown criteria:
Car
Repaired
= J3
Car
Repair date known
= J3
Car
Repair to be scheduled
= J4
Van
Repaired
= I4
Van
Repair date known
= I4
Van
Repair to be scheduled
= I5
Thanks so much for your help with this, it's really been struggling with this one.
Thank you
Lauren