Problem with looking up a value.
Hi Jan,
Am Mon, 20 Oct 2014 03:48:54 -0700 (PDT) schrieb Jan Kronsell:
I have an array, looking something like this (but with other numbers)
0.1 0.2 0.3 0.4.....
1 1 5
2 1 5
3 1 5
4 1 5
.
try:
=INDEX(1:1,MATCH(Udregninger!B31,INDIRECT(MATCH(Ud regninger!B30,A1:A80,0)&":"&MATCH(Udregninger!B30, A1:A80,0)),0))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|