Excel VBA find, match and append worksheet values?

I am in need of VBA code that performs the following function(s):

If any cell in Workbook 2, Sheet 1, Column B = any cell in Workbook 1, Sheet 1, Column B, then match value in Workbook 1, Sheet 1, Column A (A, B, C, etc) and enter matching result in Workbook 2, Sheet 1, Column A.

Please Login or Register  to view this content.

Result should be as follows on Workbook 2, Sheet 1:

Please Login or Register  to view this content.

As I am a complete novice with VBA code, I am not aware if macros can be executed to check against multiple workbooks. If not, I could always combine the data on one workbook, and use Sheet 1 and 2 - if necessary. Alternatively, I could have all the data in Sheet 1 only if that makes it even simpler.

Thanks for your time and input.

Welcome to the Board.

If you post a question on multiple forums please ensure you detail them appropriately (as per Forum Rules)

x-posted: http://www.mrexcel.com/forum/showthread.php?t=475651

Why a macro instead of a simple formula?