Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Need Help...Linking Columns

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Detroit
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Detroit
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...?

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Detroit
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...


    :: Pharma Z - Family drugstore ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •