I am trying to use index match to return a descriptive value from a range, I am either doing it wrong or using the wrong method for my needs.

I have a sheet named SKU that holds the name of the client in Row 1 beneath the clients name is a list of SKU codes the next column holds the description of the SKU codes which is what I want to return the value of

I have a sheet named PRINT NOTE with the name of the client in cell B1 and the name of the SKU in cell A20.

If I use the following match reference =match($B$1,SKU!$C$1:$AR$1,0)
B1 = Multipower
B1 = BOA
B1 = CCE_Monster

Then it returns the correct values i.e.
1 for Multipower
3 for BOA
7 for CCE Monster

IndexMatach.JPG

I now want to find the relevant SKU description.

Exp 1
On sheet “PrintNote”
Cell B1 contains ‘CCE_Monster’
Cell A20 contains ‘G9’
Cell B20 contains the Index Match formula to return the description required

I therefore want the value in J7 to be returned to B20 I appreciate that I have found it is in the 7th column and now I want to count down 7 rows and return the value 1 to the right, but I can’t get the formula right

Exp 2
On sheet “PrintNote”
Cell B1 contains ‘Mars_Chillers’
Cell A20 contains ‘DEIMOS’
Cell B20 contains the Index Match formula to return the description required

I therefore want the value in H5 to be returned to B20

Any help would be much appreciated.

Many thanks