Ok all, I'm struggling a bit again...I'm close but can't seem to get this "simple" formula working....

Basically looking for it to reference two data entry points and compare them to decide whether to return data from Column F or Column G....


If User Enters a (1) in Cell C22 then return value from column F4:F17


If User Enters a (2) in Cell C22 then return value from column G4:G17

I've attached an example sheet.

Please help! Example (2).xlsx