how to match values from 2 different sheets

[chavanalini]

Hi,

I have 2 excel sheets attached sample file

I want my output in Sheet2 which was highlighted in yellow in sample attached file


Please anyone can help me to do this with excel functions

Thanks in advance

[sandy666]

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[chavanalini]

thank you so much for your suggestion, I have edited my post.

[sandy666]

I give up
Tried to understand algorithm which is used in your example but no success.

but
try:
Sheet2, B2: =IFERROR(IF(MATCH(B$1,Sheet1!$B2:$P2,0)>0,"Yes",""),"") drag to the right and down

[chavanalini]

Thank you so much for your help. its working.

Regards

[sandy666]

You are welcome
.
.
If problem is solved mark thread as solved and read my dancing footnote