|I need some clarification:|
First - The columns in your example don't line up so it's hard to tell what is what. Try using the pre and /pre codes to format your post.
Second - What is meant by A B A? Are they supposed to be Column labels? Wouldn't that be A B C?
Third, and beyond...
Starting in cell A2 if it equals X then it would populate column B, cell B2 with Y
Where are you determining what X is (the search string) and where are you getting Y from?
Column A will have a date included that needs to be ignored during the search and replace.
Ignoring the date might be easy. However, you asked about searching Column A and populating Column B. Where does replace fit into this question?
I would like to use some sort of look-up table that would be located in a different file
And the purpose of this table would be what?