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

RE: Vlookup function for EXCEL97

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

use =if(isna(c13),"Check...","")


Frank Yang, P.E.
Senior Engineer                                   BERGER/ABAM Engineers Inc
Voice: 206-431-2374                                33301 Ninth Avenue South
Fax:   206-431-2250                             Federal Way, WA  98003-6395
e-mail: yang(--nospam--at)                         

-----Original Message-----
From: Eddie Gonzalez [mailto:Eagonzal(--nospam--at)ENG.CI.LA.CA.US]
Sent: Thursday, May 20, 1999 2:51 PM
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