Forum Discussion
Solved
2 way lookup
Hi, I am trying to look for products from column B in column F. Once found I want to compare the 'capacity' with 'quantity'. If quantity is less than capacity for that product I want to display...
Thank you for the update. With that perhaps like
=IFERROR(INDEX($B$2:$B$8,AGGREGATE(15,6,1/($C$2:$C$8<=INDEX($G$2:$G$12,MATCH($B$2:$B$8,$F$2:$F$12,0)))*(ROW($B$2:$B$8)-ROW($B$1)),ROW()-ROW($K$1))),"")Please check in attached.
In column B there are few entries for each product code. If found, sum quantity for all locations to compare with capacity?
No, I need to compare each one and display the results.
"..to display location, product code and quantity" - product code is already displayed in column F. Where to display location and quantity?
Although product code is displayed in column F that column is fixed and i need to re-display product code from column B along with location and quantity in another table.
I have attached my worksheet.
Thank you for the update. With that perhaps like
=IFERROR(INDEX($B$2:$B$8,AGGREGATE(15,6,1/($C$2:$C$8<=INDEX($G$2:$G$12,MATCH($B$2:$B$8,$F$2:$F$12,0)))*(ROW($B$2:$B$8)-ROW($B$1)),ROW()-ROW($K$1))),"")Please check in attached.