+ Reply to Thread
Results 1 to 3 of 3

excel lookup not working

  1. #1
    Registered User
    Join Date
    03-19-2009
    Location
    manchester
    MS-Off Ver
    Excel 2003
    Posts
    5

    excel lookup not working

    Hi

    I am trying to get the following:

    I have data in one sheet containing various weeks. I have created a control box so yuo can select a week but it isn't working properly because i have the syntax in the formula wrong.

    My Syntax in the cells goes like this:

    =(IF(ISNA(VLOOKUP(A13,'31 day patients data radio'!A:H,8,FALSE)), "-",(VLOOKUP(A13,'31 day patients data radio'!A:H,8,FALSE))))

    In A13 there is a key. In the other sheet in column H is the key but i want to say:

    If The key matches whats in A13 then put the value in column F in the cell.

    Can anyone help? got to submit this by tomorrow

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: excel lookup not working

    Hi,

    It's not quite clear what you're asking. Does column A of your A:H table contain the values from A13?
    Untested since we don't have your workbook, but try

    Please Login or Register  to view this content.
    If not upload your actual workbook

    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-19-2009
    Location
    manchester
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: excel lookup not working

    Thanks for your help.

    There was tiny error in my formula.

    Thanks

    Paul

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1