From: "John W. Bryan" <jaybryan(--nospam--at)voicenet.com>
Date: Tue, 25 May 1999 08:52:37 -0400
Try "conditional formatting" in the "format" menu, if you want to highlight
cells that meet certain criteria.
From: Eddie Gonzalez [mailto:Eagonzal(--nospam--at)ENG.CI.LA.CA.US]
Sent: Thursday, May 20, 1999 5:51 PM
Subject: Vlookup function for EXCEL97
Hello, need some feedback on use of Vlookup.
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?