View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default look any text in a range

Try the combination of INDEX-MATCH or VLOOKUP.

--
John Mansfield
cellmatrix.net


"fsdias" wrote:

I have 2 ranges: One range with empty and filled cells and another with
dates. I´d like that Excel give the date from the second range that
correspond to the first filled cell in the first range. Is there any formula
that solves my problem?