Using Match funtion in VBA; getting inconsistent results

[Wedge120]

Workbook 1 holds a table of information. Workbook 2 is where I run the macro. It temporarily opens Workbook 1 to return information using the Match function, populating column AF in workbook 2 based on whether a match is found.

For each row where a match is found in workbook 1, workbook 2 should populate column AF with the text "360 on-hand".
The problem is that the macro will return "360 on-hand" for some of the matches, and will not for others that in fact do match, leaving column AF blank. I have highlighted yellow about 5- 6 examples in both workbooks where the Match should work, but does not. The “match” is simply ignored.

For the code to work, please edit the path to point to wherever workbook 1 resides. Then open workbook 2 and run the macro.

Workbook 1 name is “J26 360 ThermoType database copy.xls”
Workbook 2 name is “export.xls"

Code is as follows:

Please Login or Register  to view this content.

J26 360 ThermoType database copy.xls
Attachment 399906

[FDibbins]

PLease dont just post files. Explain what you want, what you have tried, and what didnt work. At least try and do SOME of the work here

[Wedge120]

Sorry, that was a complete accident. I know better than to just post files. In my efforts to make a coherent post, i deleted the content. Apologies, but corrected now.

[FDibbins]

haha ok, no problem, I have clicked save before i was finished, myself

[Wedge120]

Edited my post to be more concise in the hopes that someone may read it