#1
|
|||
|
|||
If lookup function
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) |
#2
|
||||
|
||||
Hi
try =IF(AS7, LOOKUP(AS7, Sheet3!$A$1:$B$25), "exact")
__________________
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 |
#3
|
|||
|
|||
Hi. I think I solved the problem. I didn't need an if function:
=VLOOKUP(AS6, Sheet3!$A$1:$B$25, 2,FALSE) Thanks. |
#4
|
||||
|
||||
Glad you found your answer
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup Macro | Cardinal2 | Excel Programming | 2 | 02-05-2013 05:50 PM |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
Possible Lookup | Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
LookUp | aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
Using the LOOKUP Command | Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |