If I have a value in one file (A1) that needs to match to a value in another file which is in two columns (A1:B1), how do I get a return in column C. Example:
File 1
A
Cat
Dog
Pig
Horse
File 2
A B
Cat Meow
Frog Croak
Dog Woof
Chick Peep
Horse Neigh
Duck Quack
Pig Oink
File 1 should now be:
A B
Cat Meow
Dog Woof
Horse Neigh
Pig Oink
This message was edited by Alexander on 2002-04-16 10:15
File 1
A
Cat
Dog
Pig
Horse
File 2
A B
Cat Meow
Frog Croak
Dog Woof
Chick Peep
Horse Neigh
Duck Quack
Pig Oink
File 1 should now be:
A B
Cat Meow
Dog Woof
Horse Neigh
Pig Oink
This message was edited by Alexander on 2002-04-16 10:15