View Single Post
 
Old 01-11-2015, 05:37 AM
Vibov Vibov is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 8
Vibov is on a distinguished road
Default 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

Reply With Quote