Good morning,
Put this in E2 and drag down:
=INDEX('AMR wTran Code'!A:A,MATCH(Data!A2,'AMR wTran Code'!F:F,0))
Also, I may be able to help a little with index match. Index finds the answer in a range based on an intersection of row # and column # (we use match for this). In this case there is only one column the answer could be in (so it's simplified), but the format is something like:
index(**answer column**,match(**what you want to find**,**Column where you want to find it**,0 [zero means exact match] )). So, it will find the trancode in the list of trancodes, and return the corresponding value from the "answer column."
Best of luck,
Bookmarks