+ Reply to Thread
Results 1 to 3 of 3

Combine IF statement with VLOOKUP and two conditions

  1. 12-26-2014, 01:11 AM #1
    adamkaufman93
    adamkaufman93 is offline
    Registered User
    Join Date
    12-26-2014
    Location
    New York City, NY
    MS-Off Ver
    2011
    Posts
    1

    Talking Combine IF statement with VLOOKUP and two conditions

    I am trying to use VLOOKUP to find cells from a table, but based on two conditions. So I want to find the corresponding cell given values that are less than one value and greater than another. I've been trying to use an IF statement with 2 VLOOKUPs but need to connect them with an AND, yet I've been unsuccessful.

    Should I be using VLOOKUP or INDEX/MATCH?

    I'm using this so far...
    IF(VLOOKUP(one column)<1.5 AND VLOOKUP(another column)>5, "Yes", "No"))

    All help would be greatly appreciated!
    Thanks!
    Reply With QuoteRegister To Reply
  2. 12-26-2014, 01:18 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Combine IF statement with VLOOKUP and two conditions

    Hi, welcome to the forum

    It would be easier to suggest answers, if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-26-2014, 01:20 AM #3
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Combine IF statement with VLOOKUP and two conditions

    Try like this...

    =IF(and(VLOOKUP(one column)<1.5, VLOOKUP(another column)>5), "Yes", "No")


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    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)

Similar Threads

  1. Trying to combine an if statement & a dual vlookup...its doing something but....
    By lhunt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 12:27 PM
  2. [SOLVED] Combine two tables under certain conditions
    By mgspk01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-31-2013, 06:47 AM
  3. [SOLVED] Combine VLOOKUP and IF statement to reorganize the data. Can someone help me?
    By vademo0o in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2013, 09:01 AM
  4. Combine a VLOOKUP and an IF statement?
    By jvegastn in forum Excel General
    Replies: 2
    Last Post: 04-28-2009, 11:21 AM
  5. Combine IF conditions
    By leo73pk in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-29-2008, 01:44 PM

Tags for this Thread

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