VLookup

[niladri20052006]

when I ma doing vlookup I ma getting some match contacts. For example I am trying match the websites with other lists. I am getting the results. But I want to show my words as "Match". For example

Website
www.cisco.com www.cisco.com (after Vlookup I am getting it)

But I want to show as

Website
www.cisco.com Match (or any text)

Is there any way to do it?

Please help!!

 

[Mike Blackman]

Hi,

Try,

=IF(ISNUMBER(MATCH("www.cisco.com",A:A,0)),"Match","")

 

[DauntingGecko]

wrap an if function around it.

=IF(ISERROR(VLOOKUP(A1,Table,2,FALSE))=FALSE,"Match","No Match")