Vlookup and Index values

[Cantrecallmyusername]

Hi,

I am looking for a formula to assist me in searching for data on one sheet to another. In my workbook A I have a column with data which I want to search in workbook b to return a value. Within WB A the values in the column are repeating in certain instances multiple times. The data in WB B is also similar in that the data in the column is represented multiple times.
The count in each workbook differs - for value "CatDog" which is common in both WB is appearing 5 times in WB a and only 3 times in WB B.

The data values in WB B is less and is essential the real count of data. I will be left with blank returns in places in WB A.
I want to pull he data in column C into WB A from WB B where the data is unique.

In the screenshot is a sample of my data..
I want to pull in the 9 unique values from WB B into WB A and leave the others blank.
Also the number of returned values will vary.

Can this be done using vlookup and index?
Will I need a macro on this, I appreciate your input and look forward to your responses

.

 

[kweaver]

What result do you want in workbook A in the B column?

 

[Cantrecallmyusername]

Hi -

What result do you want in workbook A in the B column?

I would like the values in Workbook B in column F in the image.
For each of the "Catdogs" in WB A I want the unique values in WB B - there should be 9 returns and the other lines in WB A should be blank.