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
Hello,

I have a 3 columns say A, B and C..
Column A has say 140 names and Column B and C have 256 names as B and C are dependent on each other.

take for example, Column A is names of companies
column B is also name of companies and column c contains symbols of column B's companies

Now my question is
is there a way in which to look up the companies names in column A against those in Column B and give the correct company symbols as the result?

1 reply

Utetopia Posts 3 Registration date Saturday April 3, 2010 Status Member Last seen April 6, 2010
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..
0