+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Formula help for Lookup and bring back text value

  1. 05-15-2012, 10:31 PM #1
    rescueme
    rescueme is offline
    Registered User
    Join Date
    05-15-2012
    Location
    Duncan BC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Formula help for Lookup and bring back text value

    I'm having difficulty with the right formula:
    I have a numerical value in cell A3 ranging from 1 to 25 on Sheet1.
    My formula is in cell D3 on Sheet1 and I want to have the value looked up in cells A1:A25 on Sheet2 and then I want it to put the text from the corresponding cell from cells B1:B25 from Sheet2. I've tried working with the Lookup formulas but I'm not getting them right.


    Karen
    [email protected]
    Reply With QuoteRegister To Reply
  2. 05-15-2012, 10:39 PM #2
    SCLai
    SCLai is offline
    Forum Contributor SCLai's Avatar
    Join Date
    08-18-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Formula help for Lookup and bring back text value

    Welcome to the forums

    Please have a go with this:
    =VLOOKUP(A3,Sheet2!A1:B25,2,0)

    Hope this helps!

    SC
    Do give a * (bottom left) if the post helped!
    Reply With QuoteRegister To Reply
  3. 05-15-2012, 10:46 PM #3
    rescueme
    rescueme is offline
    Registered User
    Join Date
    05-15-2012
    Location
    Duncan BC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formula help for Lookup and bring back text value

    Great Problem solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1