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

Re: Vlookup function for EXCEL97

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Eddie:

This works:

=IF(ISERROR(VLOOKUP(C12,WSHAPES,42,FALSE)),"Check Shape
Size",VLOOKUP(C12,WSHAPES,42,FALSE))

-Mike

*********************
> From:          Eddie Gonzalez <Eagonzal(--nospam--at)ENG.CI.LA.CA.US>
> 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 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?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Michael Valley                                   E-mail: mtv(--nospam--at)skilling.com
Skilling Ward Magnusson Barkshire Inc.                  Tel:(206)292-1200
1301 Fifth Ave, #3200,  Seattle  WA 98101-2699          Fax:        -1201