Prev: how do i import data from my excel worksheet into quickbooks
Next: _xlfn prefix
From: teylyn on 18 Feb 2010 04:48

Here a version with the labels in row 3 and the data starting in row 4

=INDEX(Sheet2!A3:F7,MATCH(Sheet1!A17&Sheet1!B17&Sheet1!C15,INDEX(Sheet2!A3:A7&Sheet2!B3:B7&Sheet2!C3:C7,0),0),MATCH(E10,Sheet2!A3:F3,0))



t
e
y
l
y
n
;
6
4
6
9
1
9

W
r
o
t
e
:


>
Hi, the following formula works with Sheet2 having the labels "Jan",
"Feb", etc in row 1. Adjust ranges to suit.
>
> =INDEX(Sheet2!A1:F5,MATCH(Sheet1!A17&Sheet1!B17&Sheet1!C15,INDEX(Sheet2!A1:A5&Sheet2!B1:B5&Sheet2!C1:C5,0),0),MATCH(E10,Sheet2!A1:F1,0))
>
> Index being non-volatile, the formula should perform reasonably fast
with larger ranges, too.
>
> regards
>
> teylyn
>
> 'The Code Cage - Microsoft Office Help - Microsoft Office Discussion'
(http://www.thecodecage.com)


--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=180322

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

 | 
Pages: 1
Prev: how do i import data from my excel worksheet into quickbooks
Next: _xlfn prefix