offset for row not working

i have a worksheet called mulogs

first column A has dates and remaining have prices ... based on price entered i want it to check when the next date for close price is for the item. but it keeps giving #value when i use offset(1,0) for the upperval...but code works fine if i remove that and use simple c.value for the upperval just cant figure out y it doesnt work when i put in the offset code for upperval

Please Login or Register  to view this content.

As Offset(1, 0) is for the cell under like you can check just reading VBA help …

yes the cell in next row under the current cell...thats wat i want to read. it its not working

Explain now your logic according to your attachment, what the code must achieve with details, samples …

ok so when data is passed as findnextdt(BOOKS,21.6.4,03-01-2020) it first dynamically finds which colprefix i.e column ,colstart i.e start row and col i.e the number of offset from column
to reach the date column to pick, using select case .Thhen it goes to the sheet mulogs and checks the concerned column i. this case for book its column B and cell value i.e c.value being b2's value and replaces therx in it and assignes it to upperval,
then it goes it sassigns the value in a row above it to lowerval i.e of call B1. i need to find the first valid occurrence hence found =0 is only when its executed. it checks if chkprice is lesser than upperval & greater than lowerval, if yes
then gets the newdt and if the date is greater than 03-01-2020 then its assigned to result and found is set to 1 and result is returned back....but it it returns only blank all the time.

As I'm a bit lost … Ok for date 03-01-2020 and BOOKS the value is cell mulogs!B3 aka 257.04277720 and not cell B2 or what I'm missing ?!

And in your passed function what could mean 21.6.4 as a value ?
No sense the reason why nothing can be found …

ok let me try explaining it again...functions tries to check where 216 falls between 2 values in case of BOOKS its blank as condition doesnt satisfy but for PENS, value passed is 27, when it reaches cell C7 in loop,it should return the date 06-01-2020 as 27 is less that c7 value 33 and greater that c6 value of 21.