Vlookup formula not working

[searchingforhelp]

Hi, I have created a formula in Sheet1 to find the EEE number in sheet2 column B. Unfortunately, I continue to receive a NA which should not be the case as the EEE number does exist. I do not need to add an IFERROR to the formula as all the EEE numbers are present.

Sheet1

Mr Excel - Copy.xlsx
	A	B	C
1	Column	Dates	Results
2	TYU-004321	1/14/2022	#N/A
3	TYU-007000	1/5/2022
4	TYU-005656	1/10/2022
5	TYU-003333	2/5/2022
6	TYU-007330	3/6/2022
Sheet1

Cell Formulas
Range	Formula
C2	C2	=VLOOKUP(A2&"-"&B2,Sheet2!$A$2:$C$6000,2,FALSE)

Sheet2

Mr Excel - Copy.xlsx
	A	B	C
1	Column	Number	Dates
2	TYU-005656	EEE-005555	1/10/2022
3	TYU-007330	EEE-007321	3/6/2022
4	TYU-003333	EEE-004372	2/5/2022
5	TYU-007000	EEE-005558	1/5/2022
6	TYU-004321	EEE-004444	1/14/2022
Sheet2

Any help you provide will be greatly appreciated.
Thank you.

 

[eastrand]

Try an XLookup instead.

Book2
	A	B	C
1	Column	Dates	Results
2	TYU-004321	1/14/2022	EEE-004444
3	TYU-007000	1/5/2022	EEE-005558
4	TYU-005656	1/10/2022	EEE-005555
5	TYU-003333	2/5/2022	EEE-004372
6	TYU-007330	3/6/2022	EEE-007321
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=XLOOKUP(A2:A6&"-"&B2:B6,Sheet2!A2:A6&"-"&Sheet2!C2:C6,Sheet2!B2:B6)
Dynamic array formulas.

 

[Fluff]

How about

=VLOOKUP(A2,Sheet2!$A$2:$B$6000,2,FALSE)

 

[searchingforhelp]

How about

=VLOOKUP(A2,Sheet2!$A$2:$B$6000,2,FALSE)

Hi Fluff. Hope all is well. Originally, I did have the formula you outlined. However, there are instances where there are duplicate TYU numbers; however, the EEE number is different. In otherwards, you will have duplicate TYU numbers but there will never be duplicate EEE numbers and dates. For example in sheet1 rows 2 and 7 have the same TYU number but different dates. In sheet2 row 4 and 7 have the same TYU number but different EEE numbers and dates. Therefore, I need the vlookup to identify the TYU number then the date and locate the EEE number associated with it.

Mr Excel - Copy.xlsx
	A	B	C
1	Column	Dates	Results
2	TYU-004321	1/14/2022	#N/A
3	TYU-007000	1/5/2022
4	TYU-005656	1/10/2022
5	TYU-003333	2/5/2022
6	TYU-007330	3/6/2022
7	TYU-004321	1/6/2022
Sheet1

Cell Formulas
Range	Formula
C2	C2	=VLOOKUP(A2&"-"&B2,Sheet2!$A$2:$C$6000,2,FALSE)

Mr Excel - Copy.xlsx
	A	B	C
1	Column	Number	Dates
2	TYU-005656	EEE-005555	1/10/2022
3	TYU-007330	EEE-007321	3/6/2022
4	TYU-004321	EEE-004444	1/14/2022
5	TYU-003333	EEE-004372	2/5/2022
6	TYU-007000	EEE-005558	1/5/2022
7	TYU-004321	EEE-003333	1/6/2022
Sheet2

 

[Fluff]

How about

=FILTER(Sheet2!$B$2:$B$6000,(Sheet2!$A$2:$A$6000=A2)*(Sheet2!$C$2:$C$6000=B2))

 

[searchingforhelp]

How about

=FILTER(Sheet2!$B$2:$B$6000,(Sheet2!$A$2:$A$6000=A2)*(Sheet2!$C$2:$C$6000=B2))

Perfect, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.