Excel - IF Function Problem - Expert Solution

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
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.