vlookup and addition

Hey Ive came up stuck. I have a table of answers on "Input" sheet which have the same value im looking up but i need in my labels to show different answers in each. for example my table is 78214 09/06/2015 MABEY HIRE LIMITED TRANSPORT/DELIVERY CHARGE INCL 78214 09/06/2015 MABEY HIRE...

I have a spreadsheet that contains several thousands of rows of data for my clients. I would like to combine the rows with the same "Unique ID" into one row but sum the data from one column("Absences") to be displayed in the new row with all of the original data. The table has this format...

:confused:Hi I fully admit to being self taught novice in all aspects of excel and have limited knowledge of its full potential. I have just joined Mr Excel as I am working on a Calculator for my wife. It currently has me completely stumped as to how I can do what I want to get done. I am...

HELLO EXCEL fans & pro's i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year] each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks i have another sheet where a user can select a period of time [start...

Hi, I have a long list with dates from google in the first comumn, and in my third column I have dates from our database where customers made a registration in our website. What I want to do in the second column(count-data) is : given the date in the first column, for example 12/7/2011 go to...

I want to add values(Qty) of all items from multiple (more than 25) sheets, all sheets has list of many items.The addition should appears in a separate sheet.I'm using vlookup & add functions but it is not working .