Match & Vlookup combine?

Hi,

I have a large table where cost of a communication call is calculated based on 5 criterias. I'm trying to create a separate spreadsheet where I can select each criteria and pull up the price match answer from my large table. I would need to be able to combine IF & Vlookup but not sure how if i want to pull my result. Please note this need to be a formula with a range as there is million of cost variation when combining the 5 different criteria.

Data Table:

A1= 4
B1= UK
C1= MOBILE
D1= FRANCE
E1= MAKE
F1= 0.03

Separate Table:

If i fill in the separate table with the same criteria as above, i want the F14 to find F1 of the data table as all criteria from A14 to E14 match all criteria from A1 to E1.

A14= 4
B14= UK
C14= MOBILE
D14= FRANCE
E14= MAKE
F14= ??

I hope this make sense, would be glad if there is a formula that could do just what i need based on a range as obviously the Data table where data need to be lookedup will contain more than one criteria option to find a match

Thank you!!!
Laurianne

Usage Table.pngCalculator.png
Hi both,

I have tried that but it doesnt work, the issue is there is a high amount of data and the formula need to match all the 5 criteria between the 2 datasheet to bring the answer from the data table into the blank calculator form. Attached some image, obviously there is millions of combination of prices but my data table only show a few.

Usage Table.pngCalculator.png

So somehow the calculator table need to find which row in the usage table which contain the same 5 different criteria and bring the price of that row into the calculator.

Let me know if that doesnt make sense, I have been trying to fix this for a while that im not sure i make sense..

Thank youu

Attached.

- The Data Table contains all the relevant info and price calculation based on various criteria.

- The Cost Analysis table contain a red cell. In function of the answers given on the calculator excel table, I want the red cell to fetch the price from the data table that correspond to all those criterias combined.

So if i filled in the calculator as below:

DATA Belgium Data UK Landline Belgium

The red cell should bring up : £0.03. This is the price that correspond to those 4 criterias match together according to the data table.

I exepct the formula to do this to be rather challenging..

Brilliant!! Thank you so much, that worked wonders, will try it on my large amount of data but this looks spot on!

Thank you,
Laurianne

Yes, i didnt combine the cells before to try the formula! Should have thought of that, simple yet brilliant