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

Question

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.

Mazzaropi · Answer

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.

Avril Yong · Answer

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	      ?

Mazzaropi · Answer

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.

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

3 responses

Similar discussions

Subscribe To Our Newsletter!