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 a variant, you can create an Age Group Table:
and use this formula:
=IFERROR(INDEX($O$2:$O$7,MATCH(L2,VALUE(LEFT($O$2:$O$7,2)),1),0),"Under 15")
and even if you change the Age Group table, the above formula will dynamically adapt to the table.
I added 09-14 in the table but didn't have to change the formula:
cheers