Consolidate data from 2 sheets

Dear,
I have a worksheet with two different data in 2 sheets. In that, sheets data may differ. I need to consolidate this data and its related value. I need all the data without repeating from two sheets.
I attached the sample sheet for your reference. Could you please solve this. Thanks in advance.

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a very infrequent user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

In Result, B2, copied down. Similar formula in C2. see sheet.

Take a look now. I would advise that you use Named ranges to set the ranges for th eformula in column A. Di you know how to do that? If not, tell me if the values in column A are TEXT or NUMBERS and i will do it for you.