What do I need to use?

[baz9d93]

Hello -- thanks for reading this post.

I am very stuck on this problem i have attached an image to explain better - i need to check Column B Title and Find all Exact Matching values from other Columns C D E F (attributes) and give an output
In Column H I J K - in order to find out which sku has which attributes

it took me 2 days to organise the attributes but I am so confused as to how to get the result I need -putting little mockup of what I am trying to acheive but the actual file contains 30000 skus and titles and 60 attributes to look for

I have been checking tutorials since last 2 days but cant find any that do what i need to

Any help will be most appreciated -

Thank you

 

[baz9d93]

I am checking on a formula if it works I iwll update the post please hold for now

 

[jolivanes]

Your A001 sku has "Braun Metal Light Indoor White" under title, "Metal" under Material, "Indoor" under Suited, "Red" under Color and "10" under Capacity in Litres.
Under Color in Column J it has White. Is this retrieved from Column B or Column E? If it is from Column E, it does not match
For A002 sku it has nothing in Columns H, I and J although it does in Columns C, D and E. Capacity in Column B is 40 and in Column E it is 20. What is it?
An example has to be representative.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[jolivanes]

OK, I think I see now what it is.
Columns C, D, E and F have the choices for sku's. Right?

 

[baz9d93]

Thank you for your replies

@ Fluff Excel 2019
@ jolivanes Yes these are the choices for the SKU

I am just testing fully the solution I have and will update here

 

[baz9d93]

Hi Guys I realised I wont be able to get the desired results I need in full doing it the way showing in the previous pic so please check new image of how it is now and how I need it to be - I tried using Find and Highlight all of the same text but I get 2 issues. 1. It was selecting for example Weight 500g and Weight per piece 5g together when I need then to be in separate columns when I tried to do find by Weight. 2. is after all values are found I cant copy those cells to paste into a new sheet get This action wont work on multiple selections error message.

 

[baz9d93]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I have been checking so many times but can not see this option is it possible to take screenshot where I can find these

 

[Fluff]

Just click on the link in post#4 it will take you to the right section.

 

[baz9d93]

Just click on the link in post#4 it will take you to the right section.

ahh finally - i had changed my email and needed to verify that again so I think these options were not showing for me then. thanks