Complex IF Formula

Hi davo. you lost me. (not that hard). Take a look at the attached and see if its what you want. If you are saying that you specifically want the text written out in the next column, it would be (assuming name in A2, Catagory (2) in B2, Original $ in C2 and result in D2) in E2
="(if "&B2& ", then do "& TEXT(C2,"$0.00") & " x " & VLOOKUP(B2,Table,2,FALSE) & ")"