Data Validation: Multiple Formulas required in 1 cell?

Hi All,

This is my First post for MSOAH. A pleasure to be here.

I currently am using Data Validation drop-downs (which are identically referenced) in a number of cells (From J10 to J19). Each entry refers to a Crew departure &/or arrival time (based on an Aircraft schedule) and crew Subsistence & allowance ($17 per day). Referenced from “K10:K19” is USD currency:

DAYS: CURRENCY:
“J10:J19” “K10:K19”
“FULL-WEEK” (References 7 Days) = “USD 120.00”
“SATURDAY (DEPART)” (References 2 Days) = “USD 35.00”
“SATURDAY (ARRIVE)” (References 6 Days) = “USD 100.00”
“TUESDAY (DEPART)” (References 5 Days) = “USD 85.00”
“TUESDAY (ARRIVE)” (References 3 Days) = “USD 50.00”

I am trying to establish a way to specifically; select a particular day in the Data Validation drop-down menu (J10:J19) and a formula automatically converting the result to “USD Currency” for each of the 5 alternatives?

So in other words, each data validation cell will have 5 matching formulas pertinent to each specific orientation (Day)?

E.G. Select “FULL WEEK” from the drop-down option and “USD 120.00” is revealed / converted?
Select “SATURDAY (DEPART)” from the drop-down and “USD 35.00” is revealed?
... “SATURDAY (ARRIVE)” = “USD 100.00”
... “TUESDAY (DEPART)” = “USD 85.00”
... “TUESDAY (ARRIVE)” = “USD 50.00”

The closest I have managed (with no real success) is as per the following formula:
IF(T26="FULL_WEEK",X26,IF(T26="TUESDAY_(ARR)",X27,IF(T26="SATURDAY_(ARR)",X28,IF(T26="TUESDAY_(DEP)",X29,IF(T26="SATURDAY_(DEP)",X30)))))

I would be so incredibly grateful if somebody could help me (in laymen’s terms)??

Sincerest Regards and thanx,

ET