formula for a cell within ranges defined by columns on different sheet

[Kay11]

Hi I am not a very experienced Excel user. I have an excel workbook (actually a Google Sheet) with data that I am using somewhat like an inventory database. I created a Google Form hoping that it would update my original sheet. However it adds to a new sheet (let's call that "Forms") with columns "Starting #" and "Ending #". Every time the Google form is submitted it adds another row under these columns.

I would like to compare each cell within one of the columns of my original sheet to see if it falls within any of the ranges as defined in "Forms" or is equal to the starting #. If the cell is within any of the ranges or is equal to any of the starting #s, I want a blank output, If not then I want the output to be the value of the cell. However I am not getting the correct output with the formula that I am using: =if(or(K3=Forms!D:D,Forms!D:D>=K3<=Forms!E:E),"",K3)

Below is what the Forms sheet looks like after 3 form submissions. Each row defines a range.

starting #	ending #
1001	1004
1016	1019
1011

<tbody>
</tbody>

Here are two of the columns of my original sheet as it appears with results from my incorrect formulathe correct outputs should be 1005 through to 1010 inclusive, 1012-1015 incl, and 1020-1024 incl. ANY HELP WOULD BE GREATLY APPRECIATED!

Column K being tested	Column with output from formula
1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 <colgroup><col style="px"width:" 100px"=""></colgroup><tbody> </tbody>	1002 1003 <colgroup><col style="px"width:" 100px"=""></colgroup><tbody> </tbody>

<tbody>
</tbody>

Thanks