If lookup function

		Microsoft Office Forums > Microsoft Excel > Excel
If lookup function

FAQ

Thread Tools

Display Modes

03-08-2013, 07:30 AM

samc

Windows 7 64bit If lookup function

Office 2010 64bit

Novice

Join Date: Mar 2013

Posts: 2

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)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 AM.