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 location, product code and quantity for that item.
Can this be done with INDEX and MATCH or will I have to use something else?
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 location, product code and quantity for that item.
Can this be done with INDEX and MATCH or will I have to use something else?