Announcement

Collapse
No announcement yet.

Nest If And Vlookup Function

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

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

    Comment


    • #3
      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

      Comment


      • #4
        Re: Nest If And Vlookup Function

        Hi Dave

        Thanks very much, that worked.

        Tracy

        Comment


        • #5


          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

          Comment

          Working...
          X