Return to index: [Subject] [Thread] [Date] [Author]

RE: Vlookup function for EXCEL97

[Subject Prev][Subject Next][Thread Prev][Thread Next]

Try using the following in the adjacent cell:

if(error.type(C13)=7,"Check Shape Size"," ")

instead of what you tried...If(C13=#N/A,"Check Shape Size"," ") 

The 7 represents the "error value" return by the ERROR.TYPE function for the
error #N/A.

You can get more info by looking up the ERROR.TYPE function in Excel help.

Another thing that you might want to consider is making use of a pull-down
menu in the sheet.  You can set it up to list all the shapes...then the user
can pick it and the spreadsheet can pull-in the data by a VLOOKUP or such.

Hope this helps.


Scott E. Maxwell, P.E.
Structural Engineer

SHG Inc.
500 Griswold Street, Suite 200
Detroit, MI  48226

Phone: (313) 442-8253       Fax: (313) 983-3636       Email:

-----------------------Oringinal Message---------------------------------
From: Eddie Gonzalez <Eagonzal(--nospam--at)ENG.CI.LA.CA.US>
To: seaint(--nospam--at)
Subject: Vlookup function for EXCEL97

Hello, need some feedback on use of Vlookup.

C12: W12x26
C13: +Vlookup(C12,Wshapes,42,False)

Problem:  I want C13 to flag a message when Vlookup returns "#N/A" because
could not find the shape such as, "Check Shape Size".  I have tried using a
nested "IF" function but doesn't seem to work.  I have also tried having the
adjacent cell, D13, read: If(C13=#N/A,"Check Shape Size"," ") but what it
returns is the value #N/A.  Any quick suggestions?

Perhaps I should be sending this request to the new listserver, but I cannot
join it yet since our network setup has a problem with the word "Admin" at
begining of an address.

ed gonzalez