Extraction of Excel data by using an Excel column parameterSolved/Closed

Question

Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2.

Sheet 1:

Model No   Product Info A     Product Info B   Product Info C ............................
A
B
C
D 
E
..........

Sheet 2:

Model No
A
C
E
K
.........

Is there any simple way to extract all the product information from Sheet 1, only for certain Model Nos in Sheet 2?

Please advise.

Thanks much..

Mazzaropi · Answer

strikewind, Good evening.

You can use a VLOOKUP  function to do this task.

If you want a more precise advise, please, save a short example of your excel file at a free site, www.speedyshare.com and put a link to download here.

Remember to put some data there and show the desired results.

Is it what you want?
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

strikewind · Answer

Hi Good morning.
I am a newbie to VLOOKUP function and would need your kind assistance to provide a detailed advice to the problem mentioned.

Below is a brief example of Sheet 1 and Sheet 2 of excel files, and the Desired Result.

Thanks much in advance.


Sheet 1:

Model No            Info 1         Info 2          Info 3          Info 4 etc.......................
AAA                     AAA1          AAA2           AAA3            AAA4
BBB                     BBB1          BBB2           BBB3            BBB4
CCC                    CCC1          CCC2          CCC3           CCC4
DDD                    DDD1          DDD2          DDD3           DDD4
EEE			   EEE1          EEE2           EEE3	    EEE4	


Sheet 2:

Model No
AAA
CCC
EEE

Desired Result:

Model No            Info 1         Info 2          Info 3          Info 4 etc.......................
AAA                     AAA1          AAA2           AAA3            AAA4
CCC                    CCC1          CCC2          CCC3           CCC4
EEE			   EEE1          EEE2           EEE3	    EEE4

Mazzaropi · Answer

strikewind, Good evening.

I did an example for you:
http://speedy.sh/uDMrF/21-08-2014-enKioskea-Sample-VLOOKUP-OK.xlsx

Attention: 
Be careful on using merged cells.
They're a nightmare on searching data on Excel.

Is it what you want?
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

strikewind · Answer

Hi. Thanks much!!

My problem is now solved.  :)

Extraction of Excel data by using an Excel column parameter

4 responses

Similar discussions

Subscribe To Our Newsletter!