+ Reply to Thread
Results 1 to 6 of 6

ISNA and vlookup

  1. #1
    Registered User
    Join Date
    10-20-2008
    Location
    Lubbock
    Posts
    9

    ISNA and vlookup

    I'm having an issue I hope someone has a solution for. I'm trying to get data from another tab, but only if it is greater than or less than a certain number. Here's what I'm using but doesn't seem to work.

    =IF(ISNA(VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE)),">=22.00%",VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE))

    A13 is targeting the name of the person
    Aim MTD is the sheet tab the info is in

    And I want to select the information only if the cell value is 22% or greater. If the cell value is less than 22%, I don't want it to read or to read zero. I'm not an excel expert (yet), but hope to be one day!
    Thanks in advance for your help!
    Juan
    Last edited by NBVC; 10-20-2008 at 07:19 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    =IF(VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE)>=22.00%,VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE),0)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    10-20-2008
    Location
    Lubbock
    Posts
    9
    You're awesome! Thanks for your help!

  4. #4
    Registered User
    Join Date
    10-20-2008
    Location
    Lubbock
    Posts
    9

    another question with this formula

    Thanks again for your help yesterday, but I have another question. What if I now want to have it search for numbers greater than a given number but less than another? So in this case, greater than 22% but less than 25%. How would I adjust the formula?

    =IF(VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE)>=22.00%,VLOOKUP(A13, 'Aim MTD'!A2:T63, 5, FALSE),0)

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    Please Login or Register  to view this content.
    Note: If you want to include 22 and 25%, then add the = after the < and the >

  6. #6
    Registered User
    Join Date
    10-20-2008
    Location
    Lubbock
    Posts
    9
    thanks again, worked like a charm!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP Function
    By Ciro in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2008, 11:37 AM
  2. Isna Vlookup
    By markswan20 in forum Excel General
    Replies: 1
    Last Post: 01-30-2008, 12:25 PM
  3. Vlookup & If?
    By pmpinguel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2007, 02:10 AM
  4. VLOOKUP questions
    By batyrjan in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-16-2006, 06:19 PM
  5. Removing #N/A returned by Vlookup
    By Jim Palmer in forum Excel General
    Replies: 2
    Last Post: 10-11-2006, 09:03 AM

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