Comparision

[jyothish8807]

Now i have a new issue frnds plz help.

i am working on 3 sheets together. in one sheet there are 5 columns which contain some catagories.

in other two sheets there were two coloumns which i compared and those compared data are mentioned in the first sheet in different catagories coloumns.

Now i want if the comparision result is "YES' then the particular catagory coloumn of shaeet on which contain the particular compared data should also show 'YES' else blank. How can i achive this?

[jyothish8807]

Now i want if the comparision result is "YES' then the particular catagory coloumn of  first sheet which contain the particular compared data, should also show 'YES' else blank. How can i achive this?

[#3]

hi

see the attachement.

[jyothish8807]

I got it.. thanx alot

[#5]

hi

if the attachement helps you, then mark helpful or correct.

[jyothish8807]

My issue was a little more complex but i solved it. Thanx a lot for the attachments..