Previous Topic Next Topic

How to pull some data from 1 Excel sheet to another automatic

Closed
Avril - Jul 27, 2016 at 05:14 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - Jul 29, 2016 at 09:04 AM
Hello,

How can I pull SOME data from sheet 1 (report) to sheet 2(table chat) automatically?

Is there a way in excel, whereby if the data in one cell (i.e. the products name ) matches, I can pull in the text from the other sheet and add it to the row so I can quickly do the next report?

I try use this format for same sheet. This format cant use for copy the text to other sheet .
=index(E2:E200,match(A1,B1:B200))


Thanks.

3 replies

Answer 1 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jul 27, 2016 at 10:04 AM
Avril, Good morning.

Scenario:

Sheet 1 (Report)
A1 --> Product Name
B1 --> Formula 1
C1 --> Formula 2
D1 --> Formula 3

Sheet 2 (Table Chat)
A1:A10 --> Product Name
B1:B10 --> Feature A
C1:C10 --> Feature B
D1:D10 --> Feature C

Formulas:

Sheet 1 (Report)
Formula 1
B1 --> =VLOOKUP(A1,Sheet2!A1:D10,2,FALSE)

Formula 2
C1 --> =VLOOKUP(A1,Sheet2!A1:D10,3,FALSE)

Formula 3
D1 --> =VLOOKUP(A1,Sheet2!A1:D10,4,FALSE)

Please, tell us if it worked for you.
I hope it helps.
0
Answer 2 / 3
Avril Yong
Jul 29, 2016 at 02:55 AM
I am sorry, I still cant do it, below is my request. how to automatically find the ITEM NAME (?)
If the SHELF AND GROUP is same, then the ITEM NAME will automatically fill in coloum 2,4,6......

SHEET 1 (REPORT)
A B C D
SHELF GROUP ITEM NAME
1 2nd 2901 JEFF
2 3rd 2901 AMY
3 2nd 2904 JANE
4 2nd 2902 AMY
5 Grd 2902 LION
6 Grd 2901 LION
7 2nd 2903 FION
8 2nd 2906 WONG
9 3rd 2902 kEAT
10 3rd 2908 VOON
11 3rd 2906 CHEW
12 Grd 2906 CHEW
13 Grd 2903 IVY
14 3rd 2903 MICH
15 3rd 2907 KOHN
16 3rd 2904 KOHN 2
17 3rd 2905 MAY
18 2nd 2905 JACK

SHEET 2 (TABLE)
A B C D E F G H I J
1 LINE 1 3rd 2901 2902 2903 2904 2905 2906 2907 2908
2 AMY kEAT ? ? ? ?
3 2nd 2901 2902 2903 2904 2905 2906 2907 2908
4 JEFF AMY ?
5 Grd 2901 2902 2903 2904 2905 2906
6 LION LION IVY ?
0
Answer 3 / 3
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jul 29, 2016 at 09:04 AM
Avril Yong, Good morning.

Ohhh. Now your explanation is clear.

You can solve this using the wonderful SUMPRODUCT Function.

I did a little example for you:
http://speedy.sh/CUEjU/29-07-2016-en-Kioskea-SOMARPRODUTO-Localiza-TEXTO-OK.xlsx

Is this what you want?
I hope it helps.

Best regards from Brazil.
0