Excel - COLUMN Function Problem - Expert Solution

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
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
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
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
Excelchat Expert 20/09/2018 - 05:01
you want it here in google sheet?
User 20/09/2018 - 05:01
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
Excelchat Expert 20/09/2018 - 05:18
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.

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.