+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP not returning correct information from given array

Hybrid View

  1. 01-03-2013, 07:08 PM #1
    raymond87
    raymond87 is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Korea
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question VLOOKUP not returning correct information from given array

    On the attached workbook I am trying to have information displayed in B5 when a selection from D4 is chosen from the list. The array is located at A69:B92 and the information that I want to be displayed is 2nd (description of each exercise B69:B92). It is currently showing some information but it is either the incorrect information for that exercise or it displays #n/a. I have used the same code multiple times and in the exact order and it works on fine then but just not now, so I am lost. I apprecaite any assistance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-03-2013, 07:12 PM #2
    dogberry
    dogberry is offline
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: VLOOKUP not returning correct information from given array

    Hi

    Add false after the 2 for an exact match.

    Chris
    Click my star if I helped Thanks
    Reply With QuoteRegister To Reply
  3. 01-03-2013, 07:27 PM #3
    raymond87
    raymond87 is offline
    Registered User
    Join Date
    11-27-2012
    Location
    Korea
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: VLOOKUP not returning correct information from given array

    Thank you so much for the assistance and prompt response! Everything is working smoothly now.
    Reply With QuoteRegister To Reply
  4. 01-03-2013, 07:29 PM #4
    dogberry
    dogberry is offline
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: VLOOKUP not returning correct information from given array

    Hi

    Your welcome thanks for the rep and dont froget to mark your thread as solved from thread tools at the top of your first post.


    Chris
    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