LinkBack URL
About LinkBacks
I'm trying to do a 2 way match using VBA, the lookup range is dynamic.
Both lastRow and lookUpvalue are set as double
Not sure if the ranges are not written correctly. any help is appreciated. Thanks
Please Login or Register to view this content.
I'm trying to do a 2 way match using VBA, the lookup range is dynamic.
Both lastRow and lookUpvalue are set as double
Not sure if the ranges are not written correctly. any help is appreciated. ThanksPlease Login or Register to view this content.
Well, this bit's wrong:Looks like it needs an "& lastrow" adding.Please Login or Register to view this content.
Counters relating to rows would normally be Long. So, both lastrow and i should be Long. lookUpvalue would be whatever you expect to get back ... but you might get an error if it's, say, blank. Maybe safer to make it a Variant.
If either of the Matches fail, you will get an Error, so you would need to use On Error Resume Next to start error trapping and then test whether or not the formula returned an error.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks so much!
I have made the lookUpvalue into a variant, here's the entire code:
Now im getting a type mismatch error on the first IF statement, comparing a value to the variant. But when I add a msgbox for the lookupvalue, it seems to be returning the correct values going through the loop. Do I have to add something to it to reformat the variant?Please Login or Register to view this content.
What happens if you change the code to this?
Please Login or Register to view this content.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks