Excel
Closed
kapuchlove
-
Apr 3, 2010 at 06:59 AM
Utetopia Posts 3 Registration date Saturday April 3, 2010 Status Member Last seen April 6, 2010 - Apr 3, 2010 at 07:28 AM
Utetopia Posts 3 Registration date Saturday April 3, 2010 Status Member Last seen April 6, 2010 - Apr 3, 2010 at 07:28 AM
Related:
- Excel
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
Utetopia
Posts
3
Registration date
Saturday April 3, 2010
Status
Member
Last seen
April 6, 2010
Apr 3, 2010 at 07:28 AM
Apr 3, 2010 at 07:28 AM
ok, 1st, this may not be the easiest way, but its quick.
1st, Keep column A empty for now, put all yr values in (column A) AWAY from the information u need you look at, for instance on Sheet2!
Your B cells run from B1:b256 and your C cells run from C1:c256
In a1, click on the Data Tab, click data validation. In the dialogue box, on the "Allow" section, click the arrow down and select "List". In the source box, type in the range of yr original A column, now on Sheet2, like this:
=Sheet2!a1:a140
That will create a drop down list, u can select each individual company with.
Leave columns B and C as they are with their 256 individual entries.
In D1, type the following formula:
=vlookup(a1,b1:c256,2,false)
If u need me to explain it, get back to me..
1st, Keep column A empty for now, put all yr values in (column A) AWAY from the information u need you look at, for instance on Sheet2!
Your B cells run from B1:b256 and your C cells run from C1:c256
In a1, click on the Data Tab, click data validation. In the dialogue box, on the "Allow" section, click the arrow down and select "List". In the source box, type in the range of yr original A column, now on Sheet2, like this:
=Sheet2!a1:a140
That will create a drop down list, u can select each individual company with.
Leave columns B and C as they are with their 256 individual entries.
In D1, type the following formula:
=vlookup(a1,b1:c256,2,false)
If u need me to explain it, get back to me..
