Yes A2 is the input cell where you have to enter the SKU Number.
Make sure whether your calculation is set to AUTOMATIC or press F9 to initiate manual calculation.
Yes A2 is the input cell where you have to enter the SKU Number.
Make sure whether your calculation is set to AUTOMATIC or press F9 to initiate manual calculation.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Oh yes, it wasn't set to automatic!! Thanks. That table is brilliant, its exactly what I had in mind.
So the formula you used, is that just finding similar volume wise? Can I edit it so it also finds, say others with the same brand but slightly different volume? So if 300g was out of stock, there's 250g or 400g?
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks