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

RE: Vlookup function for EXCEL97

[Subject Prev][Subject Next][Thread Prev][Thread Next]
On Friday, May 21, 1999 5:51 AM, Eddie Gonzalez [SMTP:Eagonzal(--nospam--at)ENG.CI.LA.CA.US] wrote:
> 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 it
> 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?

Try this:

=IF(ISERROR(C13),"Check Shape Size","")

Regards,

Dave Meney
Principal Structural Engineer
Yenem Engineering Services
Perth, Western Australia