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. #1
    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


  2. #2
    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

  3. #3
    Join Date
    15th October 2003
    Posts
    188

    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


  4. #4
    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


  5. #5
    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. 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
  •  
porno