Forum Discussion

Fatih_Polat's avatar
Fatih_Polat
Copper Contributor
Feb 07, 2020
Solved

Excel IF-formula

Hi all,   I'm looking for the easiest formula for the IF-function.    This is what I'm exactly looking for:   If C2 = V-838-NN then N2 has to be € 70,83.    So each licence plate/vehicle has ...
  • Riny_van_Eekelen's avatar
    Feb 07, 2020

    Fatih_Polat 

    You want a more dynamic solution than just with IF. The attached workbook has a simple example how you combine a table containing plates and cost with cell that displays the cost (using VLOOKUP) for a selected plate (using Data Validation).