Extraction of Excel data by using an Excel column parameter [Solved/Closed]

Report
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
-
strikewind
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
-
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..

4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014

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.
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014

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
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014

Hi. Thanks much!!

My problem is now solved. :)