**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to find all values in Sheet 2: Column B that match the values in Sheet 1: Column C-X and return the values in Sheet 1: Column A to Sheet 2: Column E.
There may be multiple matches and these need to be Comma Separated (or in separate columns and I can concatenate them afterwards)
If some sample data is required please let me know.

Solved by T. W. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
08/02/2018 - 11:22

Added some sample data to Sheet 1 & 2

Excelchat Expert
08/02/2018 - 11:22

Hi, Thank you for using Got It Pro.
I’m happy to be able to help you today.

Excelchat Expert
08/02/2018 - 11:22

Great

Excelchat Expert
08/02/2018 - 11:23

okay, let me reiterate

Excelchat Expert
08/02/2018 - 11:23

column A in sheet 2 matches data in columns from D to N in sheet 1

Excelchat Expert
08/02/2018 - 11:23

is that correct?

User
08/02/2018 - 11:24

Sheet 2: Column A matches Sheet 1: Column B - X

User
08/02/2018 - 11:24

(Sorry I deleted a few columns before adding the sample)

Excelchat Expert
08/02/2018 - 11:25

no worries

Excelchat Expert
08/02/2018 - 11:26

ok so when Sheet2 column A matches column B-X it retrieves the SKU in column A sheet 1

Excelchat Expert
08/02/2018 - 11:26

and adds it to column B sheet 2

Excelchat Expert
08/02/2018 - 11:26

correct?

User
08/02/2018 - 11:26

Returns to Column C +

Excelchat Expert
08/02/2018 - 11:26

okay

User
08/02/2018 - 11:26

There'll be multiple matches and I want those in Column C, D, E etc.

Excelchat Expert
08/02/2018 - 11:26

do you mind if I change the layout of the data in sheet1

Excelchat Expert
08/02/2018 - 11:27

yes got it

User
08/02/2018 - 11:27

Go for it

Excelchat Expert
08/02/2018 - 11:27

thanks

Excelchat Expert
08/02/2018 - 11:27

okay

Excelchat Expert
08/02/2018 - 11:44

can you give me an ID sheet2 column A that matches anything in sheet 1

Excelchat Expert
08/02/2018 - 11:44

because they all seem not to match

User
08/02/2018 - 11:45

10742

Excelchat Expert
08/02/2018 - 11:46

okay, it works in row 1508 sheet2

Excelchat Expert
08/02/2018 - 11:49

please check the solution I provided

Excelchat Expert
08/02/2018 - 11:49

and ask any question you might have

User
08/02/2018 - 11:49

Sorry it crashed on me

User
08/02/2018 - 11:50

Just loaded it back up

Excelchat Expert
08/02/2018 - 11:50

no worries yeah it did that with me too

Excelchat Expert
08/02/2018 - 11:50

because it's handling lots of data

Excelchat Expert
08/02/2018 - 11:50

with array formulas

Excelchat Expert
08/02/2018 - 11:50

which requires lots of processing power

User
08/02/2018 - 11:51

It does looks as though it's working

User
08/02/2018 - 11:51

From what I can see

User
08/02/2018 - 11:52

Is their anyway I can copy this over to my excel doc without it crashing?

Excelchat Expert
08/02/2018 - 11:52

you can check row 1456 in sheet2

Excelchat Expert
08/02/2018 - 11:52

you can download the file itself

Excelchat Expert
08/02/2018 - 11:52

File -> Download as -> Excel Spreadsheet

User
08/02/2018 - 11:52

Oh actaully

User
08/02/2018 - 11:53

I don't think it has worked I'm afraid

User
08/02/2018 - 11:54

CFFMFST should be in anything in the category 9121 but it's not on that list

Excelchat Expert
08/02/2018 - 11:54

which row is that?

User
08/02/2018 - 11:54

1456 - 1461

User
08/02/2018 - 11:55

They're all category 9121

User
08/02/2018 - 11:55

According to the other Sheet, SKU CFFMFST should be showing for that category ID

Excelchat Expert
08/02/2018 - 11:55

okay let me check

User
08/02/2018 - 11:55

Row 46 on Sheet 1

Excelchat Expert
08/02/2018 - 11:55

okay

Excelchat Expert
08/02/2018 - 12:05

I adjusted the formulas

Excelchat Expert
08/02/2018 - 12:06

it's just calculating

Excelchat Expert
08/02/2018 - 12:06

It's taking some time because of the size of the data

User
08/02/2018 - 12:06

No problem

User
08/02/2018 - 12:06

I will wait :)

User
08/02/2018 - 12:07

Are you guys freelancers that work for this company then? Never seen a system like this, I was fully expecting to post on a forum somewhere asking for help when this popped up.

Excelchat Expert
08/02/2018 - 12:08

Got It Pro is a platform that connects experts to the who ever needs help in a particular field

User
08/02/2018 - 12:16

The formula's still calculating?

Excelchat Expert
08/02/2018 - 12:16

working on a workaround

Excelchat Expert
08/02/2018 - 12:16

to take less processing power

Excelchat Expert
08/02/2018 - 12:16

one moment

User
08/02/2018 - 12:16

Thanks

User
08/02/2018 - 12:19

It hasn't popped up asking if I want more time, this time.

User
08/02/2018 - 12:19

What happens if it cuts me off

Excelchat Expert
08/02/2018 - 12:19

the session will end

Excelchat Expert
08/02/2018 - 12:19

I'm trying to finish the workaround

Excelchat Expert
08/02/2018 - 12:19

downaload the sheet anyways in 30 secs I will be done then

Excelchat Expert
08/02/2018 - 12:19

it's take time to calculate on your computer

User
08/02/2018 - 12:19

Okay

Excelchat Expert
08/02/2018 - 12:20

okay I'm Done

Excelchat Expert
08/02/2018 - 12:20

File -> Download as -> Excel Spreadsheet