Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » Formula Issue

Formula Issue

Previous | Next
Latest post Thu, Jun 5 2008 3:41 AM by Bob Phillips. 1 replies.

  • Wed, Jun 4 2008 5:25 PM

    • nina
    • Top 500 Contributor
    • Joined on Wed, Jun 4 2008
    • Posts 1
    • Points 21

    Formula Issue

    Reply |Contact

    I need help....its been awhile since I worked on Excel and formulas.  Some of the formulas came easily but now I am stuck.  Can anybody help me?  Here is what I am needing. 

     

    Worksheet One                                                                  Worksheet Two

    Name                   Location                                                 Name                  SS#

    JOhn Smith            Texas                                                                           999-99-9999

    Peggy White          South Carolina                                                              999-99-999

     

    I am trying to write a formulas in worksheet two that will help lookup worksheet one by location and give me a name.  for example. lookup texas in cell b1 and obtain cell a1 and give me the text (value) into worksheet two in A1.  I hope this makes sense.  But any help you may have would be great....
    • Post Points: 21

  • Thu, Jun 5 2008 3:41 AM In reply to

    Re: Formula Issue

    Reply |Contact |Mark as Answer

    =INDEX(Sheet1!A:A,MATCH("Texas",Sheet1!B:B,0))

    Regards

    Bob

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.