+ Reply to Thread
Results 1 to 5 of 5

IF Statement where Logic Test is a cell that contains a Vlookup

  1. #1
    Registered User
    Join Date
    05-19-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    IF Statement where Logic Test is a cell that contains a Vlookup

    HI,

    I'm having a brain freeze.. and may not have tackled this in the best way.. but here is my issue.

    I have a Nested If that is testing for 2 cells being blank and if they are then it returns blank... (i know I could use ISBLANK).. but my issue is the IF statement further in...

    =IF(AND(AH4="",BH4=""),"",IF(FL4>74.9,"A2","AS"))

    Cell FL4 contains a Formula... =IFERROR((VLOOKUP(BH4,A2_Pts,2,1)),"")

    So Excel appears to be stating that the Cell contains a number greater than 74.9... as it is a formula..
    The Vlookup is pulling a range of values depending upon what is entered on another cell..

    Any help would be appreciated..

    Thanks

    Dave

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: IF Statement where Logic Test is a cell that contains a Vlookup

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-19-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: IF Statement where Logic Test is a cell that contains a Vlookup

    Almost cracked it.. sorry I think I didn't explain myself... The issue that I have now is that FL4 can be blank... my issue is that "AS" should be showing... as I have only got data "A" in AH4... and BH4 is blank..so FL4 SHOULD return Nothing.. but it doesn't as the formula is there.. I wondered if it is the IFerror..

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: IF Statement where Logic Test is a cell that contains a Vlookup

    Dave

    The IF statement will only be looking at the value in the cell, it makes no difference if that value has been typed in or is the result of a formula.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    05-19-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: IF Statement where Logic Test is a cell that contains a Vlookup

    Hi,

    Yup I think I know where the issue is... it is the IFERROR, as this is giving me "".. as the Vlookup is returning "N/A".. my trouble is now.. I can't have anything numeric appearing in FL4.. as it is used for calculations so even 0 will knock everything out... an interesting one..

    I might redesign this so that it does the lookups in one formula... then the iferror can still be used... just not looking forward to running through the logic!

    thanks for your help guys..
    Last edited by dcraggs; 05-19-2014 at 07:28 AM.

+ 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. Replace cell value based on a logic statement
    By spujr in forum Excel General
    Replies: 5
    Last Post: 01-17-2014, 04:56 PM
  2. Logic Test ?
    By Zeno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2006, 01:45 PM
  3. [SOLVED] MORE THAN ONE LOGIC TEST
    By jan kay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2006, 09:45 PM
  4. Need help on Logic test!!!
    By jbf frylock in forum Excel General
    Replies: 5
    Last Post: 01-09-2006, 05:45 PM
  5. hpw do I logic test a cell then copy the row to diff. SS
    By Debi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2005, 05:05 PM

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