Search for, and extract data

[MIKEBIZ]

​

	A	B	C	D	E	F	G	H	I
1	TODAY'S DATE:	WITH/WITHOUT PAY:					DATE EMPLOYEE LEAVING	DATE EMPLOYEE RETURNING	WITH OR WITHOUT PAY
2	11-9-2015						10-30-2015	11-2-2015	WITH
3							11-7-2015	11-14-2015	WITHOUT
4							12-25-2015	12-26-2015	BIRTHDAY PAY

<tbody>
</tbody>

HELLO, WHAT I'M TRYING TO DO IS WRITE A FORMULA IN CELL B2 THAT WILL CHECK IF TODAY'S DATE (A2) IS >= DATE EMPLOYEE LEAVING (COLUMN G) AND AT THE SAME TIME
A2 < DATE EMPLOYEE RETURNING (COLUMN H). IF BOTH CONDITIONS ARE TRUE, I WOULD LIKE IT TO RETURN THE VALUE FROM COLUMN I. IF ONE OF THE CONDITIONS IS NOT TRUE,THEN "". THANK YOU IN ADVANCE FOR YOUR HELP, THIS PROBLEM IS DRIVING ME CRAZY

 

[JoeMo]

Not realy, its exactly what Im looking for but it keeps giving me #ref error

Is your sheet layout the same as the one I posted? Have you used Formulas>Formula Auditing>Evaluate formula to see where the error is?