View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Swyne Swyne is offline
external usenet poster
 
Posts: 2
Default What command to use?

Thanx a million Max

"Max" wrote:

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
---