Multiple IF + Most recent date

**ScaniaR730** · 05-14-2019, 10:34 AM

Hello!
Can anyone help me out with this?

I want the worksheet-DATE, column D to search for column A + B and answer with most recent date.
https://ufile.io/4pg6uxfn

**canapone** · 05-14-2019, 10:42 AM

Hi

an attempt

=LOOKUP(2,1/(('BASE INFO'!$B$2:$B$155=A2)*('BASE INFO'!$C$2:$C$155=B2)*('BASE INFO'!$D$2:$D$155=C2)),'BASE INFO'!$A$2:$A$155)

Regards

**davsth** · 05-14-2019, 10:49 AM

as above
=LOOKUP(2,1/((Tabell1[Kundnamn]=Tabell2[@Kundnamn])*(Tabell1[Angöring namn - sista]=Tabell2[@[Angöring namn - sista]])*(Tabell1[Angöring postort - sista]=Tabell2[@[Angöring postort - sista]])),Tabell1[Datum])

**ScaniaR730** · 05-19-2019, 02:26 AM

Could one you guys put hte formula in the file?
I got a swedish version of Excel and can't really figure out the formula

**canapone** · 05-20-2019, 01:20 AM

Hi,

please refer to the attachment.

hälsningar från Florens

Multiple IF + Most recent date

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Multiple IF + Most recent date

Re: Multiple IF + Most recent date

Re: Multiple IF + Most recent date

Re: Multiple IF + Most recent date

Re: Multiple IF + Most recent date

Thread Information

Users Browsing this Thread

Similar Threads

Find the most recent date from multiple rows with same lookup Value

Find Most Recent Date corresponding to Unique ID from Multiple Workbooks

[SOLVED] Lookup Multiple Criteria using most recent date

[SOLVED] VLOOKUP based on multiple criteria with most recent date

[SOLVED] Multiple criteria lookup including recent date.

text within multiple strings, look @ dates in next column, return most recent date

[SOLVED] How to: Compare multiple dates and enumerate cell in row with most recent date

Bookmarks

Bookmarks

Posting Permissions