Lookup with multiple variables

[genichigo]

Hi guys,

I will try to explain to my best ability for this,


Im stuck on how to do this specific lookup, on my example

On the summary sheet im looking to do a lookup in column E, which will lookup in the CMS Dump sheet.

It would Match the "Login ID" from Summary A3 in the Column B in the CMS Dump file, but will return the values linked to it on the DATE in column A with the date in D1 on the summary Page.

It would then ideally return the earliest LOGIN from Column F on the CMS Dump, But these are not necessarily in order.

Then in the reverse in column G on the summary sheet would do the same lookup, but return the LAST entry on the date, from Column I

I get lost on the lookup for across two lookups

Any insight would be awesome thanks!