Need FORMULA help please!!

[marislav]

Hello, Please help with formula in Col D Table 1 to lookup values from Col H Table 2. Thank you in advance. 

1	A	B	C	D	E	F	G	H
2	Table 1		Table 2
3	PRODUCT ID	COMMENT CODE	COMMENT DATE	Lookup Value From Table2  Column H		PRODUCT ID	COMMENT CODE	COMMENT DATE
4	000101	ABC1	02/04/2016	07/07/2019		000099	ABC1	07/05/2019
5	000101	ABC2	02/06/2016	07/08/2019		000100	ABC2	07/06/2019
6	000103	ABC1	02/06/2016	07/11/2019		000101	ABC1	07/07/2019
7	000103	ABC2	02/07/2016			000101	ABC2	07/08/2019
8	000104	ABC3	02/08/2016	07/07/2019		000103	ABC1	07/11/2019
9						000103	ABC2
10						000104	ABC3	07/07/2019

[#2]

Hi@marislav 

Please use below formula in Col D of Table 1:

VLOOKUP(C6,$H$6:$I$12,2,0)

Sample file is also attached for more understanding.

Thanks,

Tauqeer

[#3 · Accepted solution]

@marislav 

As variant for

in D4

=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")

[#4]

Thanks a lot, that's what I need @Sergei Baklan 

[#5]

@marislav , you are welcome