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)

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi. I think I solved the problem. I didn't need an if function:

=VLOOKUP(AS6, Sheet3!$A$1:$B$25, 2,FALSE)

Thanks.

Glad you found your answer

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post