If macro picking up 5 inputs changing to 3 outputs

Hi all,

I'm trying to take 5 inputs that are all in text format and inputs have fixed options what i need is a macro that will take them and turn them in to the relevant outputs. there is a select amount of combinations and i've been asked to do each combination as a separate macro or sub macro.


What i have so far is;

If C6 = "Panel plate" And D6 = "24 by 21" And E6 = "<1.59" And F6 = "N/A " Then I6 = "120" And j6 = "4" And L6 = "120"
End Sub

A B C D E F G H I J K L
1
2
4
5
6 Panel plate 24 by 21 <1.59 N/A
7
8
9
10

(Doesn't seem to work)
If those four cell match up then i need I6-L6 to line up with whats required.
If they don't equal that i need it to stay clear.
I also need to add the same macro with different options
I'll take any advice or any other options that are easier.

Thanks in advance, any question feel free to comment.

Cheers for the quick reply i've tried that still doesn't work :P

Thanks again but still no, would a copy of the file help?

plating calc..xlson sheet 2 there is the combinations i need a calculator on one row that when the 1st section is selected the 2nd half is filled it. finish and plating addition are not need at the moment so ignore them

thanks a lot for all you help.

Cheers
Andrewg23