vlookup
 

Hi all,

vlookup, looks up a value and then place it somewhere else.
I would like to know if there's a way to do the opposite. That is, if I
find a value, don't display it, but if the value can't be found by vlookup,
place some character in the cell to indicate it as such? Is there a way to
do this? Thanks for sharing your thought.

Ben



--

Hi,

=IF(ISERROR(VLOOKUP(A2,$D$2:$D$10,1,0)),"x","")
Here, if A2 does not have a match in D2:D10, an 'x' is returned.

Regards,
B. R. Ramachandran

"Ben" wrote:

Hi all,

vlookup, looks up a value and then place it somewhere else.
I would like to know if there's a way to do the opposite. That is, if I
find a value, don't display it, but if the value can't be found by vlookup,
place some character in the cell to indicate it as such? Is there a way to
do this? Thanks for sharing your thought.

Ben



--

=IF(ISNA(MATCH(<your value,<your table, 0)),"###","")


On Wed, 5 Oct 2005 12:29:05 -0700, Ben wrote:

Hi all,

vlookup, looks up a value and then place it somewhere else.
I would like to know if there's a way to do the opposite. That is, if I
find a value, don't display it, but if the value can't be found by vlookup,
place some character in the cell to indicate it as such? Is there a way to
do this? Thanks for sharing your thought.

Ben

Wow, what a great idea,
thanks B. R. and Myrna.

Ben

--



"Ben" wrote:

Hi all,

vlookup, looks up a value and then place it somewhere else.
I would like to know if there's a way to do the opposite. That is, if I
find a value, don't display it, but if the value can't be found by vlookup,
place some character in the cell to indicate it as such? Is there a way to
do this? Thanks for sharing your thought.

Ben



--