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