Creating a complex index match formula

Excel version: 2602, Microsoft 365

Hey everyone,

I am currently creating a kinda complex (at least for me) index matching formula and would like some opinions on how to flush this out as it’s been a while since I’ve done one like this.

I need to input data (price) into a cell based on data (a name) in a cell on the same sheet and compare that name to a price point on another sheet based on another set of information which is also available on both sheets.

So it would basically be lookup based on name and type to input a price based on name and type from another sheet. But there’s two “types” per name and each also have a different price point…. Hope this all makes sense 🫠

Any advice would be wonderful, thanks!

(Photo in comments)