|re: If I can avoid VB that would be nice...maybe a macro solution|
You are aware that macros are written in Visual Basic, don't you? Excel uses VBA (Visual Basic for Applications) for Excel as the programming language for writing macros.
Depending on what you are trying to do, you might be able to use VLOOKUP to get the results you want.
With this list in Sheet1:
and this list in Sheet2:
Put this someplace and drag it down 3 cells