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
