If and Vlookup

[TlgKill]

Hello im trying to create a formula using an If and vlookup formula where "if" it meets these criteria then lookup in the price column that matches the if's logic statement. can this be done? I have attached a sample of what i want below.

Sample.xlsx

[Ace_XL]

Try this array formula..

=INDEX($U$3:$U$22,MATCH($A3&$B3&$C3&$D3&$E3,$O$3:$O$22&$P$3:$P$22&$Q$3:$Q$22&$R$3:$R$22&$S$3:$S$22,0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[TlgKill]

Thank you it worked :D