find 2 values i a table to find the right prise
Hi
i have this table, and i want to find 2 values in the table below to find the right price
When i enter IV i A1 and FV i B1 i want excel to find the price 3.345,00 and write in cell F1 but how do i do that?
Thanks
MArtin
I II III IV V
Mini 760,00kr. 1.050,00kr. 1.125,00kr. 1.185,00kr. 1.315,00
FV 1.825,00kr. 2.285,00kr. 2.940,00kr. 3.345,00kr. 3.810,00
LV 3.370,00kr. 4.010,00kr. 4.905,00kr. 5.565,00kr. 6.195,00
|