help needed in indirect function

TehseenAfzal

New Member
Joined
Sep 6, 2006
Messages
8
hi all

can anybody help me to anderstand this formula

=MATCH($D$2,INDIRECT("'Journal and accounts'!d"&A5+1&":d"&4+'Journal and accounts'!$C$2),0)+A5

please explain me i have a worksheet holding this formula.

tehseen
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
INDIRECT returns the reference specified by a text string. If A5 contains 1 and C2 on sheet "Journal and accounts" contains 10, INDIRECT will return a reference to:

'Journal and accounts'!D2:D14

which is used by the MATCH function.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,687
Members
410,698
Latest member
Wloven
Top