Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
 -
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..
See more

4 replies

Answer 1 / 4
Posts
1838
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2020
 136
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
Report
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.
Answer 2 / 4
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
Answer 3 / 4
Posts
1838
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2020
 136
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
Answer 4 / 4
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
Hi. Thanks much!!

My problem is now solved. :)
Ask a question