|
|
|
|
#1
01-11-2015, 05:37 AM
|
|||
|
|||
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 
|
|
#2
01-11-2015, 07:25 AM
|
||||
|
||||
|
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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode