#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find what box in Find and replace limits the length of a search term | Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
Macro that can find phrase and then find another and copy | jperez84 | Word VBA | 10 | 09-19-2012 04:48 PM |
Bad view when using Find and Find & Replace - Word places found string on top line | paulkaye | Word | 4 | 12-06-2011 11:05 PM |
VBA find or name a Table | smed | Word VBA | 1 | 01-17-2011 02:18 PM |
How to find RBG values for Office 2003 palette? | alicorn2 | Outlook | 2 | 07-10-2009 02:24 PM |