Search for, and extract data

[MIKEBIZ]

​[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]TODAY'S DATE:[/TD]
[TD="align: center"] WITH/WITHOUT PAY:[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DATE EMPLOYEE LEAVING[/TD]
[TD="align: center"]DATE EMPLOYEE RETURNING[/TD]
[TD="align: center"]WITH OR WITHOUT PAY[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]11-9-2015[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10-30-2015[/TD]
[TD="align: center"]11-2-2015[/TD]
[TD="align: center"]WITH[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11-7-2015[/TD]
[TD="align: center"]11-14-2015[/TD]
[TD="align: center"]WITHOUT[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]12-25-2015[/TD]
[TD="align: center"]12-26-2015[/TD]
[TD="align: center"]BIRTHDAY PAY[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
















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?