Advice for Project - What to use: Dictionary, collection, array, reference workbook?

Looking at auto-populating a field based on user input values. There is no calculation involved in determining the number, just locating the value based on user's input. For example...

User inputs: [size], [material], [part name]

Output: [cost]

the cost values are tabulated by part name, then the size and material correspond to y&x index or size = row, material = column.

What I need to do is find the easiest way to implement the data. The cost sheets are to be input manually (only printed files exist w/o digital copies ) and this will be a tedious undertaking as there are dozens of them with RxC ~ 25x15 for each but the sizes vary for each. But before we start on that, it's important to know which direction to head. Any input on how I should go about doing this? I'm looking for the least taxing and most efficient storage solution since the workbook will frequently be updated and shared. Options I'm considering are a reference workbook of tables (this will likely be easiest for data entry, but expensive for VBA) and I'm not sure about the pro/con for dict. or coll. or arrays as I am new to VBA and have not used these yet! The cost values will not change with time and are not dependent. Have not yet considered pivot tables, but I'm open to anything since we're in the infancy stage here.

Do you guys have any input on how I should go about this?

I would use a Userform.

Luckily for you I need a project to mork on at the moment.

They are very powerful and can make your data entry very intuitive and robust.

Once created. You can use as many text boxes as you want to filter your data. You do not have to enter data in all of them.

So Maybe: Description Starts with: "Meter",
Description includes: "Volts",
Description includes: "Megger",
Minimum Price: 100
Maximum Price: 1000

On the Userform a Listbox can then be populated with a list of all "Megger Volt Meters costing between 100 and 1000

You click on the one you want to populate you list.

This is just an illustration.

You first step is to create your database in the format that works best for you.

Only once your database is ready can you start creating the Userform.