vlookup and display

[guna_sekar87]

I have a Master data in Coloumn A and Input data in Coloumn B.

Now, I need to search each data of Coloumn B in all the range of datas of Coloumn A(i.e Master).

If that Input Data is present in Master Data,then I need to display “Present in Master” in Coloumn C, if it is not present then I need to display “Not present in Master” in column C.

Please give a formula for this type of display in Coloumn C.

I have attached the document in the below link:


http://www.fileconvoy.com/dfl.php?id=gfae0a2c898bcea609992461803015e87af5b19f50

 

[guna_sekar87]

NEED YOUR KIND HELP

 

[vasim]

=IFERROR(IF(VLOOKUP(B2,$A$2:$A$500,1,0)=B2,"Present in Master",0),"Not present in Master")

 

[Debraj]

Hi Guna,


In C2 Write Formula as..

=IF(COUNTIF($A$2:$A$205,B2),"Present in Master","Not Present in master")

Regards,

Deb


PS: Yes, you can mail me mail3debraj[at]gmail[dot]com

 

[guna_sekar87]

hi team,


how to display with colour differentiation...."green" for present in master and "red" for Not Present in master in this formula....


Thanks and regards,

guna

 

[sdsurzh]

Hi,


Use Conditional format. Can you please refer the below links it will help you to learn conditional format.


http://chandoo.org/wp/excel-tutorial/using-conditional-formatting/

http://www.exceltraining.org.uk/excel-2007-2010-conditional-formatting-tutorial


Thanks,

Suresh Kumar S