return number from range if in tolerance

[BHudPE]

I want to check the numbers in Col-C one at a time against the numbers within the range (A1:A12)i n Col-A. If the Col-B number is within a tolerance of any Col-A number, I want to store the Col-A number in Col-D. If the Col-B number not within the tolerance of any number in Col-A, then store the Col-C number in Col-D.

note: There are duplicate numbers in Col-A and not all cells in Col-A range have numbers in them. The Col-C numbers will always be filled with numbers.

attached is file with data setup on Sheet1, and the macro.

The line I am having problems with is....

Please Login or Register  to view this content.

1) I need to correct the code in the line above.
2) Any suggestions on a better approach would be greatly appreciated.


SOLVED BY AUTHOR
HERES WHAT I CAME UP WITH

Please Login or Register  to view this content.