Related:
- Extraction of Excel data by using an Excel column parameter
- Excel data validation list show 2 columns - How-To - Excel
- Excel column index to number - How-To - Excel
- How to determine cell value in Excel column ✓ - Forum - Excel
- Compare mutliple Excel columns ✓ - Forum - Excel
- Compare two excel Columns of differant size ✓ - Forum - Excel
4 replies
Mazzaropi
- Posts
- 1868
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 15, 2021
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
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
- 1868
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 15, 2021
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
Subscribe To Our Newsletter!
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.