Auto fill-in more than one column with words

[Z62688116]

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

 

[Dave Peterson]

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.