Date match

**Margate** · 12-23-2017, 04:48 PM

Done. I have attached a spreadsheet (My attempt.xlsx) following your instructions. I have one of my attempts at a solution in but it does not work at all.

**samba_ravi** · 12-23-2017, 05:12 PM

f2=LOOKUP(E2,$B$2:$B$6,$A$2:$A$6)

=LOOKUP(E2,$B$2:$B$6,$A$2:$A$6)

Try this and copy towards down
if the result is in date format, change the cell format as general/number

**Margate** · 12-23-2017, 05:22 PM

Perfect. Seems like quite a straight forward formula! I may may have been over complicating it but there is just so much going on in Excel that I just get totally confused especially after trying to find solutions for several hours!

Thank you very much for your help and patience. This is caused me a real headache!

Much appreciated.

Margate.

Date match

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Date match

Re: Date match

Re: Date match

Thread Information

Users Browsing this Thread

Similar Threads

Index Match to find match date to a range of dates

[SOLVED] How to Match or Lookup the the qty to other specific cell that match the date

vlookup or index match with multiple conditions (Date closest match) in pivot table

[SOLVED] Index Match Based on One Date Criteria, Table Contains Beginning Date and End Date

[SOLVED] INDEX date that MATCH on date range, MATCH code(string)

Date Match in all worksheets according to Main Sheet if not match insert row adjust

Date change & TBA when match cancelled. Try Match and index didn't work

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions