Auto fill-in more than one column with words

Hi, the problem I have is this.
Let's say you have three columns.
Country, Currency, Company.

If I fill in the country column "Japan", is there a way to have i
automatically fill in "Yen" in the currency column?

Also - if the company is already filled in - is there a program I ca
create or run that will go through thousands of lines of data so tha
it auto fills in "Japan" and "Yen"?

Lastly, for programs like this, are these classified under VBA or Macr
or something else?


Greatly appreciate the answer as I am having difficulty locating it

--
Message posted from http://www.ExcelForum.com

Dave
Wed Jun 02 18:56:33 CDT 2004

I'd use a formula approach.

First I'd insert a new worksheet that held the names of the countries in column
A and the name of the currency in column B. (Say it's called sheet2.)

Then insert this in B2:

if(a2="","",if(iserror(vlookup(a2,sheet2!a:b,2,false)),"missing",
vlookup(a2,sheet2!a:b,2,false)))

(all one cell)

And drag down as far as you need.



"Z62688116 <" wrote:
>
> Hi, the problem I have is this.
> Let's say you have three columns.
> Country, Currency, Company.
>
> If I fill in the country column "Japan", is there a way to have it
> automatically fill in "Yen" in the currency column?
>
> Also - if the company is already filled in - is there a program I can
> create or run that will go through thousands of lines of data so that
> it auto fills in "Japan" and "Yen"?
>
> Lastly, for programs like this, are these classified under VBA or Macro
> or something else?
>
> Greatly appreciate the answer as I am having difficulty locating it.
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
ec35720@msn.com