User Profile
D7d7ono
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
formula help
Looking to return a single cell value with multiple criteria. Sheet1 Column A - List of Customer codes Column B - List of Product codes Column C - Prices Sheet2 Product code in cell A2 Customer code in cell B1 In cell B2 i want to pull in the price from sheet1 where it finds the matching product and customer code. But 2 factors to consider, in sheet1 there can be multiple customer and product codes that are the same (which do show the same price) so SUMPRODUCT cannot be used as it adds up the prices if it finds the match one than once. And I cannot use INDEX and MATCH as the formula falls over in the jet report I have written. Any help appreciated1.6KViews0likes7CommentsMultiple match and lookup
Sheet 1 Column h6:h20 (list of product numbers) Column i6:i20 (list of customer numbers) Column j6:j20 (list of prices) Sheet 2 Cell f7 (a product number, that can be matched in Sheet1 h6:h20) Cell z4 (a Customer Number, that can be matched in sheet1 i6:i20) In sheet 2 I want a formula that looks up cells f7 and z4 (in sheet 2) and finds a match in sheet1 and then pulls through the price from (sheet1 J6:j20 range)1KViews0likes3CommentsFormula Help - Extract, Match
After some help with below I have a list where I want to extract (from column B into cell F1 any colours that appear in Column B but no duplicates) Then in cell G1 i want this to total all the 'Red' with the total value from column c. So F1 = Red G1 =58 F2 = Blue G2 = 8 F3 = Yell G3 = 3 A B C D E F G 1 Red 12 ** ** 2 Blue 5 3 Yell 3 4 Red 34 5 Red 12 6 Blue 3839Views0likes2Comments
Recent Blog Articles
No content to show