Results 1 to 6 of 6

Simple cross-reference formula

This is a discussion on Simple cross-reference formula within the Excel Questions forums, part of the Question Forums category; I'm trynig to retrieve the data from a cell that is next to a cell with a certain value. Here's ...

  1. #1
    New Member
    Join Date
    Jun 2003
    Posts
    4

    Default Simple cross-reference formula

    I'm trynig to retrieve the data from a cell that is next to a cell with a certain value.

    Here's what I'm talking about:

    Apple 1
    Boy 2
    Cat 3
    Dog 4

    If cell a6 is 4, then I want cell a7 to display "Cat".
    This is probably really simple, but I'm pretty new to excel and couldn't figure it out.
    Thanks in advance!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: Simple cross-reference formula

    Assuming that your data is in A1:B4, try this formula in B6

    =INDEX(A1:A4,MATCH(A6,B1:B4,0))
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,945

    Default

    Hi - welcome to the board!

    Review the help file for vlookup - post back if you need more.

  4. #4
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    West Bridgford, Notts., England
    Posts
    2,834

    Default Re: Simple cross-reference formula

    Quote Originally Posted by lennon74
    I'm trynig to retrieve the data from a cell that is next to a cell with a certain value.

    Here's what I'm talking about:

    Apple 1
    Boy 2
    Cat 3
    Dog 4

    If cell a6 is 4, then I want cell a7 to display "Cat".
    This is probably really simple, but I'm pretty new to excel and couldn't figure it out.
    Thanks in advance!
    a7=if(a6=4,"cat","") etc

    Edit: that was the not looking answer! Check PaddyD's suggestion!
    Iridium


  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default Re: Simple cross-reference formula

    Actually, Paddy's wont work either, because this is (If I understood correctly) a left-hand lookup, which can be achieved using INDEX/MATCH.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  6. #6
    New Member
    Join Date
    Jun 2003
    Posts
    4

    Default Re: Simple cross-reference formula

    Works perfect, thanks for all your quick responses!

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
  •  


DMCA.com