It doesn't pick up the cell address, it picks up the value that is one cell
to the right of the looked up value

This will do the same and is more efficient

=INDEX('Capital Summary'!G$25:G$28,MATCH(A4,'Capital Summary'!F$25:F$28,0))


If you want the cell address you can use

=CELL("address",INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital
Summary'!F$25:F$28,0)))



--


Regards,


Peo Sjoblom


"Dave F" wrote in message
s.com...
I have the following formula:

=OFFSET(INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital Summary'!F
$25:F$28,0)),,1)

This works fine, however, when I remove the OFFSET(...) part and just
have

=INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital Summary'!F$25:F
$28,0))

the matched value is returned, not its cell address. How does OFFSET
pick up the cell address?