Return Value Based on Criteria

Morning All

Can you please advise the formula to return a value based on the below please.

If Line 2 for example has 5 units and is of type X and X = £0.06, the value should be returned as £0.30

Thanks in advance
John

Hi Shareez

Many thanks but not working for me. I assume i am copying and pasting your formula into C2?

Thanks
John

C2 cell formula , Drag down

HTML Code: 

Perfect, many thanks wk9128

Hi Again

wk9128's formula worked perfectly, but if i try to add a further or change the array it falls over.

i have attached my actual worksheet and deleted and sensitive material. The only one that works is ETD, what am i doing wrong?

Thanks

J4 cell formula

HTML Code: 

Because LOOKUP Function must be sorted first

The lookup formula must be in alphabetical order
=F4*(LOOKUP(I4,{"DOGS","ETD","RAY"},{0.15,0.11,0.06}))

Thanks so much both, simple when you know i guess

Many thanks and have a fab rest of day.

Glad to help & thanks for the feedback.