View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default MATCH Multiple Criteria & Return Previous / Penultimate Match

Hi Domenic,

Thank you. The file's linked to multiple files. I'll try and get sample file
to you tomorrow.
However, I may have to recap where all the data lies.

Cheers,
Sam

Domenic wrote:
At this point, I think it would be easier if you sent me a sample file
and I'll make the necessary adjustments. Otherwise, for clarity, you'll
have to recap where all the relevant data lies, provide the defined
names and their references, provide the actual formula you're using, and
specify in which cell the formula will first be entered.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200710/1