Hey fellas whatsup, i was trying achieve indexing or matching data from "data" sheet to "income" sheet here, would like to know if there is any function or formula i can use to achieve this.
Based on Order ID in "income", i will need to collect back all Parent SKU Reference No., SKU Reference No., and Quantity from "data", and some of the order ID comes with multiple SKU or Quantity, this is where i am stuck, i mean i could achieve only if the ID itself have only 1 item sold, with =vlookup(b2,"data",4), I wont be able to get the other data. Could use a little bit of help here? Thanks guys!
Bookmarks