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 ...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    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).

Fatih_Polat's avatar
Fatih_Polat
Copper Contributor
Feb 07, 2020

Subodh_Tiwari_sktneer 

 

Thank you so much. It was the Vertical Lookup formula that was missing. 

 

Now it's working. 

Thanks !