I would need some help to create a very simple Excel function, i think its a Vlookup function that is needed. Please check the attached sample.
1. The LOOKUP TABLE sheet is where all the data will be store
2. The SUMMARY sheet is where the info will be displayed, the info is retrieved from the Lookup table sheet.
So for example:
If (Summary / A column) has any value that is store in (Lookup table / Colunm D to M), the function should be able to retrieve the corresponding SKU / Price / Weight located in (Lookup table / Column A,B,C) and paste the result in the (Summary / Column B,C,D)
I believe this is very simple task for you, please simply let me know how much you would like to charge me.
Thank you once again for your precious help!