**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.*