Compare tow alphanumeric numbers and return a value

New to VBA and Macros so I apologize if this is trivial...(also I apologize if I am not clear)

I have two worksheets titled "Electrical Bid Items" and "2011 Weighted Average Bit Price". All items are numbered in the following format (701.1234('x') with 'x' being either a capital letter or a number.

"Electrical Bid Items" contains a complete list of items that pertain to me. This list contains items not in the "2011 Weighted Average Bit Price" list.

Ex...(all in Column A)
701.12345
701.1234A
701.12346
701.4566Z


"2011 Weighted Average Bit Price" contains many entries I am not interested in and that are not included in the "Electrical Bid Items" list as well. This List however contains recent prices for its items.

Ex...(all in Column A)
701.12342
701.1234A
701.12346
701.1244B
701.4566Z


What I would like to accomplish is a script that selects each item in the "Electrical Bid Items" list compares the items alphanumeric number to every entry in "2011 Weighted Average Bit Price" list until it finds a match and then return the related price of that item.

So far I have been able to create the script below, however, it will ignore any entry with a letter. It does successfully compare the number only items and returns their value.

Please Login or Register  to view this content.

I have tried several different way of accomplishing all of this but the above is my most recent iteration...not sure if the best though.

Thanks For any help and let me know if more information is needed.

Well I have now...but all I succeeded in doing is making myself more confused.