Excel If and Vlookup

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • 66Nana
    New Member
    • Jul 2013
    • 3
    #1

    Excel If and Vlookup

    I have a drop down box where users select a Town. I have a formulae that says VLOOKUP(A13,Tra velRates,2. A13 is the town from the drop down list. This works fine and a rate is calculated. However, there are 3 rates I need to use depending upon mileage eg 50-99, 100-200,201-300. I think it is =IF then vlookup but I am completely lost. Can anyone PLEASE put me on the right direction.

    A huge thank you in advance
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      What trouble are you having with the IF function?

        Comment

        • Killer42
          Recognized Expert Expert
          • Oct 2006
          • 8429
          #3
          One possibility would be to replace the column number (2) in your Vlookup with a cell value that indicates which rate to look up.

            Comment

            Previous template Next
            Working...