Question description:
This user has given permission to use the problem statement for this
blog.
i need a formula that read the cells in C and then copies column A B and C in to a new sheet
Solved by C. E. in 34 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/09/2018 - 04:49
Hi
Excelchat Expert
20/09/2018 - 04:49
How are you doing
User
20/09/2018 - 04:49
hi
User
20/09/2018 - 04:50
hi im doing good
User
20/09/2018 - 04:50
thanks
Excelchat Expert
20/09/2018 - 04:50
Can you provide a sample excel
User
20/09/2018 - 04:50
ok hold up
Excelchat Expert
20/09/2018 - 04:50
sure
User
20/09/2018 - 04:53
okay are you ready
User
20/09/2018 - 04:53
what i want is
Excelchat Expert
20/09/2018 - 04:53
yes
Excelchat Expert
20/09/2018 - 04:54
Yes
User
20/09/2018 - 04:54
in sheet two C1 and C2 i want it to search sheet1 and then populate a and b
Excelchat Expert
20/09/2018 - 04:55
ok so if you have a value in column C sheet 2 you want the corresponding value of column A and B from sheet 1
Excelchat Expert
20/09/2018 - 04:55
right?
User
20/09/2018 - 04:56
yes and then placed in sheet2 column a and b
User
20/09/2018 - 04:56
tracking is and details address
Excelchat Expert
20/09/2018 - 04:56
ok Let me build a formula please stay here
User
20/09/2018 - 04:57
*tracking id
User
20/09/2018 - 04:57
thnaks
Excelchat Expert
20/09/2018 - 04:57
:)
Excelchat Expert
20/09/2018 - 04:59
Please verify
[Uploaded an Excel file]
Excelchat Expert
20/09/2018 - 04:59
The formula is a combination of Index and Match
Excelchat Expert
20/09/2018 - 05:00
I have placed the formula till row 20 od Sheet 2.. If you enter the Values in Column C A and B will automatically populate..
Excelchat Expert
20/09/2018 - 05:00
If you need more rows all you need to do is drag the formula
User
20/09/2018 - 05:00
i cant see it
Excelchat Expert
20/09/2018 - 05:01
Sheet 2
[Uploaded an Excel file]
Excelchat Expert
20/09/2018 - 05:01
you want it here in google sheet?
User
20/09/2018 - 05:01
yes google sheets
User
20/09/2018 - 05:01
would be fine
Excelchat Expert
20/09/2018 - 05:01
ok 1 min
Excelchat Expert
20/09/2018 - 05:02
I sent you an excel just in case
Excelchat Expert
20/09/2018 - 05:03
you can check sheet 2 in the preview Google sheet
User
20/09/2018 - 05:03
but in coiumn c sheet2 there are more that 2 tracking is for them poctal
Excelchat Expert
20/09/2018 - 05:05
ohh .. there are multiple rows... for each postal
User
20/09/2018 - 05:05
yes
Excelchat Expert
20/09/2018 - 05:05
hmm
Excelchat Expert
20/09/2018 - 05:06
give me few min .. when the timer stricks 2 min you will receive an extension please click yes
User
20/09/2018 - 05:06
okay
Excelchat Expert
20/09/2018 - 05:06
you need both the Postals or just 1 at a time?
User
20/09/2018 - 05:07
both
Excelchat Expert
20/09/2018 - 05:07
hmmm
Excelchat Expert
20/09/2018 - 05:07
in Google sheet or excel.. this is important as it is an array formula ...
User
20/09/2018 - 05:08
excel
Excelchat Expert
20/09/2018 - 05:08
Ok will update the excel and send it
Excelchat Expert
20/09/2018 - 05:09
few min
Excelchat Expert
20/09/2018 - 05:18
[Uploaded an Excel file]
Excelchat Expert
20/09/2018 - 05:18
Please Verify the solution
Excelchat Expert
20/09/2018 - 05:19
Sheet 2 contains the formula to get all the data with the 2 Postals ..
Excelchat Expert
20/09/2018 - 05:19
Its an array formula
Excelchat Expert
20/09/2018 - 05:20
As of now it only gets data matching to D2 and D3 of sheet 2 data from sheet 1 onto sheet 2
Excelchat Expert
20/09/2018 - 05:20
I have also applied filter in sheet 1 so that you can verify the solution
Excelchat Expert
20/09/2018 - 05:21
Do let me know if you have any queries regarding the formula
User
20/09/2018 - 05:23
thank you so much
Excelchat Expert
20/09/2018 - 05:24
:)
User
20/09/2018 - 05:24
wizzkid
Excelchat Expert
20/09/2018 - 05:24
Please do leave a feedback at the end of the session :)
Excelchat Expert
20/09/2018 - 05:24
Have a nice day
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.