Previous Topic Next Topic

Extraction of Excel data by using an Excel column parameter

Solved/Closed
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
 - Aug 21, 2014 at 05:50 AM
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
 - Aug 21, 2014 at 11:46 PM
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..
Related:

4 replies

Answer 1 / 4
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Aug 21, 2014 at 06:26 PM
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
0
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
Aug 21, 2014 at 09:56 PM
Hi Good morning,

As advised, I have save a short example of the excel files and the desired results in www.speedyshare.com, and you may retrieve it from the following link:

http://speedy.sh/8xwqs/Sample.xlsx

For your kind assistance, please. Thanks much.
0
Answer 2 / 4
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
Aug 21, 2014 at 09:17 PM
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
0
Answer 3 / 4
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Aug 21, 2014 at 10:29 PM
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
0
Answer 4 / 4
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
Aug 21, 2014 at 11:46 PM
Hi. Thanks much!!

My problem is now solved. :)
0