How to use add multiple entries in a single column using vlook up
How to use add multiple entries in a single column using vlook up
Last edited by sac0011; 07-10-2019 at 08:57 AM. Reason: FILE ADDITION
I'm afraid this is a little vague (at least for me). Can you please add a representative sample of what you are trying to achieve.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
HTH
Regards, Jeff
Hello i have attached the sample sheet . Need your help for the same.
This is not a VLOOKUP - it's a SUMIF:
=SUMIF($A$2:$A$9,H6,$B$2:$B$9)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I using the same with multiple sheets so need to know how is it possible through vlookup
VLOOKUP is not suitable for summing. SUMIF, SUMIFS and SUMPRODUCT are the functions you will need to choose between.
Provide a more meaningful set of sample data.
Is there any way of doing this using sum command and vlookup together???
Provide a more realistic sample of data (workbook with more than one worksheet of data) so that we can see exactly what you are attempting to achieve.
Why are you so intent on using VLOOKUP?
Please check updated sample file. Also refer sheet 1 for outcome and sheet2 sample raw data ( comes as a outcome of a software )
Explain the fifth answer on the sheet:
Excel 2016 (Windows) 32 bit
A B C 6BSH WM12T460IN WASHING MACHINE 7.000 18
Sheet: Sheet1
Where does the 18 come from?
Waiting for an answer to my question.
sorry for late reply. actually there is multiple entry of BSH WM12T460IN WASHING MACHINE. ONE WITH 7 IN THIRD COLUMN AND ANOTHER WITH 11 WHICH IS MISSING IN SAMPLE DATA.
This, then:
=SUMIF(Sheet2!$A$3:$A$64,A2,Sheet2!$D$3:$D$64)
As I have said all along, you do not need VLOOKUP for this calculation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks