Remember Me?

#1
May 23rd 05, 01:49 PM
 steve alcock Posts: n/a
offset problem list not sequencial

Hi team,

=OFFSET(Alicia!P1,MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P \$500),1)

is looking for a value of 7193 on alicia then parse further information
along the range to the originator,although 7193 is in the list it is not in a
sequencial list and cannot be found.
Can anyone point me in the right direction as to how I can find the value,
7193, that is not held in sequencial order ?.

many thanks

steve

#2
May 23rd 05, 02:14 PM
 Duke Carey Posts: n/a

add a 0 or false as a new, 3rd argument to the Match function

MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P\$500,0)

"steve alcock" wrote:

Hi team,

=OFFSET(Alicia!P1,MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P \$500),1)

is looking for a value of 7193 on alicia then parse further information
along the range to the originator,although 7193 is in the list it is not in a
sequencial list and cannot be found.
Can anyone point me in the right direction as to how I can find the value,
7193, that is not held in sequencial order ?.

many thanks

steve

#3
May 23rd 05, 02:25 PM
 steve alcock Posts: n/a

Hi Duke,

It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((&
morning !!!

many, many thanks :-)

steve

"Duke Carey" wrote:

add a 0 or false as a new, 3rd argument to the Match function

MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P\$500,0)

"steve alcock" wrote:

Hi team,

=OFFSET(Alicia!P1,MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P \$500),1)

is looking for a value of 7193 on alicia then parse further information
along the range to the originator,although 7193 is in the list it is not in a
sequencial list and cannot be found.
Can anyone point me in the right direction as to how I can find the value,
7193, that is not held in sequencial order ?.

many thanks

steve

#4
May 23rd 05, 02:56 PM
 Duke Carey Posts: n/a

You're very welcome, & thanks for the nice words

"steve alcock" wrote:

Hi Duke,

It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((&
morning !!!

many, many thanks :-)

steve

"Duke Carey" wrote:

add a 0 or false as a new, 3rd argument to the Match function

MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P\$500,0)

"steve alcock" wrote:

Hi team,

=OFFSET(Alicia!P1,MATCH(\$C22,Alicia!\$P\$1:Alicia!\$P \$500),1)

is looking for a value of 7193 on alicia then parse further information
along the range to the originator,although 7193 is in the list it is not in a
sequencial list and cannot be found.
Can anyone point me in the right direction as to how I can find the value,
7193, that is not held in sequencial order ?.

many thanks

steve

 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 George Andrews Excel Worksheet Functions 3 May 22nd 05 12:12 AM Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:48 AM jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 06:48 PM Steve Excel Worksheet Functions 0 January 30th 05 10:11 PM B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 02:48 PM

All times are GMT +1. The time now is 07:57 AM.