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
strikewind Posts 4 Registration date Thursday August 21, 2014 Status Member Last seen August 21, 2014 - Aug 21, 2014 at 11:46 PM
Related:
- Extraction of Excel data by using an Excel column parameter
- Excel marksheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 21, 2014 at 06:26 PM
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
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
Aug 21, 2014 at 09:17 PM
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
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 21, 2014 at 10:29 PM
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
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
Posts
4
Registration date
Thursday August 21, 2014
Status
Member
Last seen
August 21, 2014
Aug 21, 2014 at 11:46 PM
Aug 21, 2014 at 11:46 PM
Hi. Thanks much!!
My problem is now solved. :)
My problem is now solved. :)
Aug 21, 2014 at 09:56 PM
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.