You need to use WorksheetFunction.VLookup twice to find the low and high
price, then do the compares, then do whatever you want with the price if it
is/is not within range.

Worksheetfunctiuon/VLookup needs a range  as its second parameter. You can use
a named  range in the spreadsheet but you need to express it as

Worksheets("worksheetname").range("rangename")

(If I didn't tell you that you would waste a couple of hours wondering why the
function was not working!)