Forum Discussion
Scott Norman
May 06, 2018Copper Contributor
Beginners Excel Lookup Question
Hi all, Please don’t fall down laughing when you read this. I want to return the “Qty Available” by each “Warehouse Code” The below output table should only show 1 x available in 612 and 935 but s...
Mark Fitzgerald
May 07, 2018Iron Contributor
In your output table, assuming it begins in cell A1 on Sheet1 and the other tab is Sheet2, enter in B3:
=SUMIFS(Sheet2!$G:$G,Sheet2!$B:$B,$A3,Sheet2!$C:$C,B$1)
Which is saying SUM Sheet2 column G IF Sheet 2 Item Code = "1103977" AND Sheet2 Warehouse Code = "610".
Drag to the right to get the other two available amounts.
The left-aligned numbers in your question suggest they are "numbers stored as text" which means you will have to convert column G to numbers to text.