Thread: MATCH Multiple Criteria & Return Previous / Penultimate Match
View Single Post
  #12   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,

Thanks for sample file.

If I try to match zero (0) EmptyText rows Formula returns #REF! error.

Also range "Data" is dynamic with many rows and columns. ID is a single
column dynamic range.

Further help appreciated.

Cheers,
Sam

Domenic wrote:
Sample file sent...

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

Reply With QuoteReply With Quote