#1
|
|||
|
|||
Formula matching multiple variables to bring back one quantity value
Need help with creating a formula. I have tried several different ways to include ifs/xlookups/index-matches but I think I might be in over my head. I am needing to update my Kit Summary sheet with the new numbers in the Order sheet. I have to match the Kit Names in column A and the Kit Numbers in column B of the Kit Summary with the Kit Names in Column A and Kit Numbers in row 1 of the Order Sheet. On top of that, I have to also match the Ordering years on the Kit Summary sheet (row 1) with the ordering years that correspond on the Order Sheet in the first column. I am having a huge issue since one spreadsheet is setup more vertically and the other spreadsheet is setup more horizontally. Any help is always appreciated. Thank you. |
#2
|
||||
|
||||
In the attached, there's a formula in cell C2 of the Kit Summary sheet:
=myQty($A2,$B2,C$1,'Order Sheet'!$A$1:$BE$8) it can be copied across and down to cell L16. Are the values returned correct? |
#3
|
|||
|
|||
I am so sorry I said that the wrong way around. I need the numbers from the Kit Summary sheet into the Order sheet, but I may be able to reverse it to the other sheet once I understand what the formula is doing. Thanks so much for your help!
|
#4
|
||||
|
||||
See pivot table at cell G11 of the Order Sheet.
|
#5
|
|||
|
|||
Thank you so much! This works.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best formula for matching column data from one workbook into another | awpatts | Excel | 1 | 05-10-2017 06:56 AM |
Need formula to determine minimum quantity needed per price | mbking | Excel | 2 | 02-10-2015 01:46 PM |
bring back deleted MicrosoftOffice files to their original location once deleted by AppCleaner | TerryWhat | Office | 0 | 01-05-2015 12:19 PM |
video over multipe slides bring to back problem | allendupras | PowerPoint | 0 | 03-28-2012 12:18 PM |
unable to bring back autoarchived emails | fireman-175 | Outlook | 1 | 08-17-2010 08:51 PM |