Thread: [Solved] Formula matching multiple variables to bring back one quantity value
View Single Post
 
Old 02-15-2024, 08:02 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 872
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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?
Attached Files
File Type: xlsx msofficeforums52081Book6.xlsx (16.9 KB, 5 views)
Reply With Quote