View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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