Can you elaborate a bit? Where is the $ value for those codes, in a column
next to the codes column? What do you mean by have a cell calculate a
different value?

"B G" wrote:

I have a lookup function question
Column AC will have one of the following disposal codes (disposal site) (PB,
EP, BL, HI, VA, MA etc)
Each of those Codes has a different $ value

I need to know if there is a way to have a cell calculate a different value
based on the Code that is column AC.

Basically we are trying to find the most profitable disposal site
--
Barb