Lookup between two dates and a vlookup

[sarao18592]

Hi, I currently have 2 sheets.
In sheet 1: I have the start date in A, End date in B and Car number in C.
In sheet 2: I have the date in C, Car number in F and name in G.

I need the name from Sheet 2 in Column D of Sheet 1.
If the date in Sheet 2(C) falls between the Start Date and End Date (sheet 1)
and the car number in Sheet 1(C) matches the car number in Sheet 1(F)

 

[Alex Blakenburg]

See if this works for you.

20210402 MultiCriteria Lookup Txt No Xlookup.xlsx
	A	B	C	D
1
2
3
4	Start Date	End Date	Car no	Name
5	1/01/2021	21/01/2021	ABC123	Name_ABC123
6
7
Sheet1

Cell Formulas
Range	Formula
D5	D5	=IFERROR(LOOKUP(2,1/((A5<=Sheet2!$C$5:$C$10)*(B5>=Sheet2!$C$5:$C$10)*(C5=Sheet2!$F$5:$F$10)),Sheet2!$G$5:$G$10),"")

 

[sarao18592]

See if this works for you.

20210402 MultiCriteria Lookup Txt No Xlookup.xlsx
	A	B	C	D
1
2
3
4	Start Date	End Date	Car no	Name
5	1/01/2021	21/01/2021	ABC123	Name_ABC123
6
7
Sheet1

Cell Formulas
Range	Formula
D5	D5	=IFERROR(LOOKUP(2,1/((A5<=Sheet2!$C$5:$C$10)*(B5>=Sheet2!$C$5:$C$10)*(C5=Sheet2!$F$5:$F$10)),Sheet2!$G$5:$G$10),"")

Thank you!
This worked perfectly

 

[Alex Blakenburg]

Glad I could help. Thanks for letting me know it worked for you.