What is the simplest way to lookup a value using VBA in Excel? Here is what I am trying to do. For each cell in a column range I am looking at the value i.e. "05569". That value corresponds to another value in my list/table i.e. "Engine". How to I extract "Engine" and enter it into another cell? Thanks in advance for your help. I know this is an easy one but I cannot figure it out using VBA (Data Dictionary, Array, List, Function VLOOKUP, etc.)???

"05569" = "Engine"
"05579" = "Plant"