I have a list of different paints and they come in various sized containers, priced accordingly.

I want to be able to type the name of the paint and the size of the container so that the price comes up automatically.

I figured out how to lookup the size of container to get the price, but only for a specific paint. I can also lookup the paint and get a row number, but I have not figured how to do both at the same time.

Any ideas? I really can't be bothered to write a C++ program to parse text files .

Or would I be better off with a different piece of software?

Suggestions?