Need Help...Linking Columns

[ubiqman]

Need some help trying to link columns together... Ex. If I put a certain number or word in column A, how can I make column B spit out something linke to it. Say if chicken=duck. How I can i type chicken in one column and make duck spit out in another... I have no idea how to do this... Any help is appreciated...

 

[Steve Hartman]

in B2, =IF(A2="chicken","duck,"")

 

[Jay Petrulis]

On 2002-04-12 08:11, ubiqman wrote:
Need some help trying to link columns together... Ex. If I put a certain number or word in column A, how can I make column B spit out something linke to it. Say if chicken=duck. How I can i type chicken in one column and make duck spit out in another... I have no idea how to do this... Any help is appreciated...

Hi,

Specific response:
A1: "Chicken"
B1: =IF(A1="Chicken","Duck","")

How many test conditions are there? A forumla that references a lookup table would probably be your best bet in this case.

Bye,
Jay

 

[ubiqman]

Thanks!!!

How could i make a formula for a table???
And can I make the formula appear in any cell...Say if i was randomly inputting chicken in one cell could the adjacent cell = duck... or do i have to specify cell columns in my formula...?

 

[ubiqman]

Maybe I can clarify better, If I have ten items that correspond to ten different items, how can I type one in any column and get the correspoding output.

Ex...
I have five items...
tree = green
car = blue
house = red
dog = black
fish = orange

How can I make it so when I type any of the five inputs in any column, I get the corresponding answer.. Can I do that...? SOrry if this sounds confusing.. I am new to the formulas... Thanks!!!

 

[Brian from Maui]

On 2002-04-12 08:40, ubiqman wrote:
Maybe I can clarify better, If I have ten items that correspond to ten different items, how can I type one in any column and get the correspoding output.

Ex...
I have five items...
tree = green
car = blue
house = red
dog = black
fish = orange

How can I make it so when I type any of the five inputs in any column, I get the corresponding answer.. Can I do that...? SOrry if this sounds confusing.. I am new to the formulas... Thanks!!!

Try VLOOKUP

Column A
tree
car
house
dog
fish

Column B
green
blue
red
black
orange

In any cell other than A1:B5
try
=vlookup(c1,A1:b5,2)

Where C1 is the cell you type in dog etc.

 

[Chris Davison]

On 2002-04-12 08:52, Brian from Maui wrote:

On 2002-04-12 08:40, ubiqman wrote:
Maybe I can clarify better, If I have ten items that correspond to ten different items, how can I type one in any column and get the correspoding output.

Ex...
I have five items...
tree = green
car = blue
house = red
dog = black
fish = orange

How can I make it so when I type any of the five inputs in any column, I get the corresponding answer.. Can I do that...? SOrry if this sounds confusing.. I am new to the formulas... Thanks!!!

Try VLOOKUP

Column A
tree
car
house
dog
fish

Column B
green
blue
red
black
orange

In any cell other than A1:B5
try
=vlookup(c1,A1:b5,2)

Where C1 is the cell you type in dog etc.

Also, try a named formula :

Try this : it needs setting up just the once :

select cell B1
insert (from the toolbar)
names
define
where it's blinking, name it something short and appropriate, like UBQ1 or something
in "refers to" type the following :

=VLOOKUP(!A1,{"chicken","duck";"tree","green";"car","blue";"house","red";"dog","black";"fish","orange"},2,0)

click on "add"
click on "ok" to exit

now, in any cell on any sheet, enter =UBQ1 next to your chicken/tree/car/house/dog entry
and you'll get duck/green/blue/red/black returned

Hopefully, also, some VBA expert will spot this post and offer an even easier way, without the need to double-enter...