I don't understand... I see how that will do the calculation if I tell it what cell to look at. But how would it work if the information is supposed to be pulled from the row of cells. Maybe I asked the wrong question. There will be 2 sheets (one sheet has the 2 columns in the excel file I attached. the other sheet will be where the user enters a value in cell B2 that would correspond to a value in Sheet1 somewhere in column A...the value I want it to return is whatever is in the B column beside the value. Does that make any sense?