![]() |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
||||
|
||||
|
Hi
your layout seems somewhat garbled but it's probably something like Code:
=INDEX($a$1:$f$4,match("fv",$a$1:$a$4,0),match("IV",$a$1:$f$1,0))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
|
|
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 |