I have a workbook (Excel 2010) that I use constantly. I am always deleting/adding rows in the main "Entry Sheet" and need the calculations in column D of my "JE Sheet" to autopopulate with the numbers in column C & D of my "Entry Sheet" based on matching information in column B on both sheets.
What formula do I need to place in column D of my JE Sheet in order to pull in the correct information from my Entry Sheet without having to manually adjust the formula each time?
I cannot seem to get a VLookup or a SUMIF to work for me and keep working even with changes, but more than likely it is user error on my part.
I have attached a sample to clarify what I need.
Thanks for any help!
D.
Bookmarks