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

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

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

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