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.

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]starting #[/TD]
[TD]ending #[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]1004[/TD]
[/TR]
[TR]
[TD]1016[/TD]
[TD]1019[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!
[TABLE="class: outer_border, width: 250"]
<tbody>[TR]
[TD]Column K being tested[/TD]
[TD]Column with output from formula[/TD]
[/TR]
[TR]
[TD]

<colgroup><col style="px"width:" 100px"=""></colgroup><tbody>
[TD="align: right"]1001[/TD]

[TD="align: right"]1002[/TD]

[TD="align: right"]1003[/TD]

[TD="align: right"]1004[/TD]

[TD="align: right"]1005[/TD]

[TD="align: right"]1006[/TD]

[TD="align: right"]1007[/TD]

[TD="align: right"]1008[/TD]

[TD="align: right"]1009[/TD]

[TD="align: right"]1010[/TD]

[TD="align: right"]1011[/TD]

[TD="align: right"]1012[/TD]

[TD="align: right"]1013[/TD]

[TD="align: right"]1014[/TD]

[TD="align: right"]1015[/TD]

[TD="align: right"]1016[/TD]

[TD="align: right"]1017[/TD]

[TD="align: right"]1018[/TD]

[TD="align: right"]1019[/TD]

[TD="align: right"]1020[/TD]

[TD="align: right"]1021[/TD]

[TD="align: right"]1022[/TD]

[TD="align: right"]1023[/TD]

[TD="align: right"]1024[/TD]

</tbody>

[/TD]
[TD]

<colgroup><col style="px"width:" 100px"=""></colgroup><tbody>
[TD="align: right"]1002[/TD]

[TD="align: right"]1003[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

Thanks