Forum Discussion
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...
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.