I have a VBA Sub that is supposed to lookup values from a Named Range and if it finds a match, hide a certain number of rows. But it’s not working. In fact, it’s producing results that I don’t understand how it reached those results.

I have a worksheet where I have a mixture of manual and automated input. I am trying to write some VBA code to first check if a cell in range is blank, and only if it is, pull date from a sheet of dates but only return the date if it is greater than or equal to today. Case numbers are in column A on both sheets but I can’t figure out how to reference them.

I have a form using application.vlookup method.
When I search a value from the first(“A”) column it works perfect.
But when I search a value from the “D” column I it refers D column as the first column and I want all the data including the A-C columns.
I’m working on private network so I can’t share the code so I write it down I hope you can understand: