If statement using vlookup

[eramirez148]

Is there a way to use a formula in column C that will generate results from column F for the matching dates only for the active rows (Column B) if a row is inactive (Column B) the the results should be an empty cell.

A	B	C	D	E	F
pos_date	Status	Results
1/1/2021	inactive			Look up list
1/2/2021	inactive			pos_date	list
1/3/2021	inactive			1/1/2021	A
1/4/2021	inactive			1/2/2021	B
1/5/2021	inactive			1/3/2021	C
1/6/2021	inactive			1/4/2021	D
1/7/2021​	inactive			1/5/2021	E
1/8/2021​	inactive			1/6/2021	F
1/9/2021​	inactive
1/10/2021​	inactive
1/11/2021​	inactive
1/12/2021​	active
1/13/2021​	active
1/14/2021​	active

 

[Sufiyan97]

Try

Book2
	A	B	C	D	E	F	G
1	A	B	C	D	E	F
2	pos_date	Status	Results
3	01-01-2021	inactive			Look up list
4	01-02-2021	inactive			pos_date	list
5	01-03-2021	inactive			01-01-2021	A
6	01-04-2021	inactive			01-02-2021	B
7	01-05-2021	inactive			01-03-2021	C
8	01-06-2021	inactive			01-04-2021	D
9	1/7/2021	inactive			01-05-2021	E
10	1/8/2021	inactive			01-06-2021	F
11	1/9/2021	inactive
12	1/10/2021	inactive
13	1/11/2021	inactive
14	1/12/2021	active	#N/A
15	1/13/2021	active	#N/A
16	1/14/2021	active	#N/A
17
Sheet1

Cell Formulas
Range	Formula
C3:C16	C3	=IF(B3="Active",VLOOKUP(A3,$E$3:$F$10,2,0),"")