Nest If And Vlookup Function
Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Nest If And Vlookup Function

  1. April 27th, 2007 #1
    TracyPat
    TracyPat is offline I agreed to these rules
    Join Date
    27th April 2007
    Posts
    11

    Nest If And Vlookup Function

    Hi

    My formula in I3 is returning the #value error. If F3 = yes, I want $3.50 put in I3 (this works by itself), then when I changed the formula to add the VLOOKUP to get the rates if F3 is blank I got the error.

    Can somebody help me with this please.

    Thanks
    Tracy
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  2. April 27th, 2007 #2
    DaveR (UK)'s Avatar
    DaveR (UK)
    DaveR (UK) is offline Established Member
    Join Date
    31st January 2003
    Location
    Portsmouth, UK
    Posts
    748

    Re: Nest If And Vlookup Function

    =IF(F3="YES",3.5,IF(F3="",(VLOOKUP(E3,Rates!A60:B61,2,FALSE))))

    should do the trick...
    D

    Better a bad day on the water than a good day in the office
    Reply With Quote Reply With Quote
  3. April 27th, 2007 #3
    Gizzmo
    Gizzmo is offline Senior Member
    Join Date
    15th October 2003
    Posts
    160

    Re: Nest If And Vlookup Function

    Hi

    Change the formula to =IF(F3="YES",3.5,IF(F3="",(VLOOKUP(E3,Rates!A60:B61,2,FALSE))))

    This should work.

    Gizzmo

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  4. April 27th, 2007 #4
    TracyPat
    TracyPat is offline I agreed to these rules
    Join Date
    27th April 2007
    Posts
    11

    Re: Nest If And Vlookup Function

    Hi Dave

    Thanks very much, that worked.

    Tracy

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  5. April 27th, 2007 #5
    DaveR (UK)'s Avatar
    DaveR (UK)
    DaveR (UK) is offline Established Member
    Join Date
    31st January 2003
    Location
    Portsmouth, UK
    Posts
    748

    Re: Nest If And Vlookup Function

    No worries - just realised that missed out a deafult (ie doesn;t met any of the other conditions) return value...

    This would return a more meaningful value than FALSE
    =IF(F3="YES",3.5,IF(F3="",( VLOOKUP(E3,Rates!A60:B61,2,FALSE)),"Not Matched"))
    D

    Better a bad day on the water than a good day in the office
    Reply With Quote Reply With Quote
« Fill Web Form | Delete Duplicate Ranges in Excel »

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Add Nest Formula/Function To Cell With Variables Via Macro Code
    By AKGold in forum EXCEL HELP
    Replies: 6
    Last Post: May 22nd, 2008, 01:33
  2. Nest IF/OR & NETWORKDAYS Functions
    By kwray49 in forum EXCEL HELP
    Replies: 1
    Last Post: May 11th, 2008, 03:34
  3. Nest Round Function Within Division
    By xindaiel in forum EXCEL HELP
    Replies: 5
    Last Post: December 14th, 2007, 07:08
  4. Nest more than 7 Formulas
    By mkmed in forum EXCEL HELP
    Replies: 14
    Last Post: July 22nd, 2006, 17:53
  5. Nest IF Formula
    By NewToXL_VBA in forum EXCEL HELP
    Replies: 6
    Last Post: November 25th, 2005, 12:01

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