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...
Sorry, I should correct the above:
"The below output table should only show 1 x available in 612 and "2 x in 935" but show 0 x available in 610:
"The below output table should only show 1 x available in 612 and "2 x in 935" but show 0 x available in 610:
Scott,
=IFERROR(LOOKUP(2,1/(Tabelle2!$B$2:$B$3=$A3)/(Tabelle2!$C$2:$C$3=B$1),Tabelle2!$G$2:$G$3),0)