Remember Me?

#1
December 1st 04, 04:39 PM
 Bob Posts: n/a

The following function returns the cell address I want to use in an offset
function:

however, if I imbed this function in the first argument of the offset
function i.e.

I get "The formula you typed contains an error." Any suggestions?

#2
December 1st 04, 04:55 PM
 Peo Sjoblom Posts: n/a

Try

having said that there is probably better to skip INDIRECT and ADDRESS and
use the match and the other data directly in either OFFSET or INDEX, this is
like swimming to the other side of the river to get a drink

For instance this

=OFFSET(A1,MATCH(C\$8,C\$10:C\$28,0)+8-1,D1-1)

would return what's in

meaning

=OFFSET(A1,MATCH(C\$8,C\$10:C\$28,0)-2,D1-1)

will return

Regards,

Peo Sjoblom

"Bob" wrote:

The following function returns the cell address I want to use in an offset
function:

however, if I imbed this function in the first argument of the offset
function i.e.

I get "The formula you typed contains an error." Any suggestions?

#3
December 1st 04, 04:56 PM
 Don Guillett Posts: n/a

Use match to find the row and then use offset from a given to use the match.
look at help for offset to see what I mean
=offset(a1,matchrow,column)

--
Don Guillett
SalesAid Software

"Bob" wrote in message
...
The following function returns the cell address I want to use in an offset
function:

however, if I imbed this function in the first argument of the offset
function i.e.

I get "The formula you typed contains an error." Any suggestions?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post outlook help New Users to Excel 7 January 26th 05 10:21 PM Hari Excel Discussion (Misc queries) 4 January 3rd 05 06:05 PM Nancy Excel Discussion (Misc queries) 1 December 20th 04 02:52 PM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM Charlie Courier Excel Worksheet Functions 1 November 24th 04 04:40 PM

All times are GMT +1. The time now is 05:37 AM.

The comments are property of their posters.