Greetings and Salutation all!
Im currently building a table that requires a fairly complex formula that I keep stuffing up...
Basically, Column A has two customer categories (A and B), column B has 3 customer subcategories (A,BC) and then columns C - F have various fields returning product information.
What I currently have is a sheet that the customer enters if they are category A or B, Subcategory A, B or C, then it returns the relevant product information in C-F. For example, Customer with a category A, Subcategory C, will return the values in C-F, all of which are returned to a unique cell.
Help!
Regards
John.
Im currently building a table that requires a fairly complex formula that I keep stuffing up...
Basically, Column A has two customer categories (A and B), column B has 3 customer subcategories (A,BC) and then columns C - F have various fields returning product information.
What I currently have is a sheet that the customer enters if they are category A or B, Subcategory A, B or C, then it returns the relevant product information in C-F. For example, Customer with a category A, Subcategory C, will return the values in C-F, all of which are returned to a unique cell.
Help!
Regards
John.