Hi,

I'm new to Excel.

I'm mapping ages to categories (e.g. age 5 to 0-5 in next field). The formula below works except for age 0, with which I get a #NAME? error.

Just wondering if anyone has any ideas about what the problem might be?

=IF(AS7, LOOKUP(AS7, Sheet3!$A$1:$B$25), exact)