Forum Discussion
IFS function not returning a result
I am an Office 365 subscriber and I am using Excel version 2109 build 14430.20298. I am new to the IFS function but it has worked in the same spreadsheet in other formulas. But in this one, I h...
As variant
=IFNA(
LOOKUP( L2,
{14,25,35,45,55,65},
{"15-24 years","25-34 years","35-44 years","45-54 years","55-64 years","65+ years"} ),
"too young")