I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad size,
price for color, etc. Then after I fill lin the the info from the advertising
contract, have Excel fill in the colums that tell me the cost for each of the
items they requested. Then apply discounts and give a final total for billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey