Hi
I have 3 suppliers, who gives me a price list and discount list.
The 6 documents have been merged to 1 to make it easier for me.
Sheet has been named after there supplier... (in my example Suppler_1, Supplier_2 etc...)
By writing the Item number in my Calculation sheet I get all the information I need...
All except who the supplier is.
Is there any formula to get the Supplier (sheet name) as a cell value depending on another cell?
I write the item nummber in cell A10 ( my Calculation sheet) and want the Supplier name (sheet name) to be displayed in cell B7.
Bookmarks