View Single Post
  #6   Report Post  
Niek Otten
 
Posts: n/a
Default

Sorry,

=INDEX(D4:G1358,MATCH(G1360,D4:D1358)-1,COLUMNS(D1:G1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"JoOwl0" wrote in message
ups.com...
Oops, that gives #NA.
=INDEX(D4:G1358,MATCH(G1360,D4:G1358)-1,COLUMNS(D1:G1))
But thanks anyway