Hi there, from Azores Islands! i need some help in a formula .

for example :

i have 3 columns , column A with 20 possible text codes , B with 70 possible number codes and C with 35 price values.

Once i type, in another cell , one text code that exists in column A, and in another cell ,one number code that exists in column B , i want to be returned a specific price value in another cell.

hope could get some help.

thanks ,Jason

**Best answer by alan.muntadas**