Hi!
I have a question about a formula.
I have to add 3 columns with the Product, Category, SubCategory using 1 formula that you can copy over the 3 columns. Use the ProductKey and the data in the WB Product for this.
I used the do this with the formula VLOOKUP but it's not the correct way.
I think I have to use the formula index and match but I have no idea what I have to do.
Thank you in advance!
I have a question about a formula.
I have to add 3 columns with the Product, Category, SubCategory using 1 formula that you can copy over the 3 columns. Use the ProductKey and the data in the WB Product for this.
I used the do this with the formula VLOOKUP but it's not the correct way.
I think I have to use the formula index and match but I have no idea what I have to do.
Thank you in advance!