Vlookup with if function

[sureshmandadpu]

Dear All,

I have a doubt with Vlookup function. My requirement is to compare data in two sheets and result should be displayed as "Not there" or "There" in the result cell. Here, I want to use Vlookup with IF function to meet my requirement. I attached file.

Please clarify my doubt.

Regards
M. Suresh

 

[Deepak]

Pls use this.

=+IF(ISNA(VLOOKUP(A5,Sheet2!$A$4:$B$7,1,0)),"NOT THERE", "THERE")

 

[sureshmandadpu]

Mr Deepak,

Thanks a lot

 

[Deepak]

Welcome!!!