View Single Post
  #1   Report Post  
steve alcock
 
Posts: n/a
Default 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