Hey,
I've tried index match, index match match (which seems like it should work but I may be using it wrong) vlookup and other formulas I've found when I've been searching for an answer. If I was returning a number it would be a simple sumifs formula, unfortunately letters are proving difficult.
Basically I have this data
sheet 1
Column A Column B Column C Column D Column E
Date Vendor Amount Employee Code
8/2/17 Amazon $100 Joe ABC
sheet 2
Column A Column B Column C
Date Amount Code
8/2/17 $100 (cell C2) This is where I need the code (sheet 1 cell E2) to automatically enter when the dates and amounts match from sheet 1 in sheet 2
I can change the code to a number and use sumifs to return the number to a hidden cell (say sheet 2 D2) but then i do not know how to have C2 read the number from D2 and convert that to a word. i.e. 1=ABC 2=DEF and so on in the same cell.
Hopefully I've explained this simply and clearly
Thanks in advance for any help
Bookmarks