How can I create a multiple IF statement and a multiple VLOOKUP within the same formula

Hello,

I am trying to create a formula which looks in 1 cell to determine 'IF' it states either "BUTT CUT" or "DIE CUT" and then does a VLOOKUP in a table array for each which ever column relates to asnwer to 'IF statement.

This is as far as I have got but even this won't work:

=IF(I15="BUTT CUT",=VLOOKUP(J15,V13:Z22,2,FALSE))

Am I going about this the right way or is there a more efficient way to do this please.

I look forward to hearing from you and thanks in advance.

Maybe
=IF(OR(I15="BUTT CUT",I15="DIECUT"),VLOOKUP(J15,V13:Z22,2,FALSE),"")

Nearly there it work with regards to BUTT CUT but not when I switch my selection to DIE CUT.

I will try to send you spreadsheet but I am struggling to see how on this forum.

to attach your sample workbook, click "Go Advanced" button and find Paperclip Button to attach the file

Regards

Thank you.

QUOTING INPUT SHEET 4.xlsm

Not sure where this formula goes but is this what you are after?

=IF(I15="BUTT CUT",VLOOKUP(J16,V13:Z22,2,FALSE),IF(I15="Die CUT",VLOOKUP(J16,V13:Z22,4,FALSE),""))

Windy

Fantastic.

This work perfectly now thank you very much for all your help Windy.

and azumi for getting me started.

bash1001

Glad to be of help. You can now mark this post as being solved.
And if you like you can click the Add Reputation button as a way of thanking those that helped.

Windy