View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default What command to use?

Correction to earlier formula in F4, sorry:
To get the burn-off, place in F4:
=INDEX(C:C,MATCH(F2,A:A,0),MATCH(F3,$B$2:$C$2,0))


In F4 should be:
=INDEX(OFFSET(A:A,,MATCH(F3,$B$2:$C$2,0)),MATCH(F2 ,A:A,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---