Vlookup in VBA or alternative to Vlookup

[vizzkid]

I'm just not having a good day with VBA..

I'm trying to find a value based on a date (found in my hist_wghts.B range). I've tried:

Please Login or Register  to view this content.

But this just returns a #VALUE-error in the entire S column.. I also tried using

Please Login or Register  to view this content.

But i think this requires that I activate the "correct" worksheet? Don't want to do that.

Is there a solution using Vlookup or should i use another method? If i should stick to vlookup, is there another way of specifying the range in which the vlookup searches as all the dates are found in vwhs.Range(B*) and all the values i'm looking for are found in vwhs.range(JD*), the middle part is useless in this part of the calculations.

*Note* Can't attach workbook due to confidentiality

[TMS]

It might help to post a sample workbook so we can see where all the data is and what the named ranges cover.

I often take the easy way out and drop a working VLOOKUP into the top cell in the range. Once it's working, I copy it and assign it to the whole range and use ".Value = .Value" to convert it to static value.


Regards, TMS