All,

I created a spreadsheet and would like some assistance in creating a
function or formula. The example below best describes the spreadsheet that I
have:
A B C D
1 AD AA CAD 70
2 AA PEN PM 60
3 PR VP LR 40

Column A = Billing Rate
Column B = Labour Code
Column C = Staff code
Column D = $ amount

On a seperate worksheet, if row showed up as AD-AA-CAD, I would like colum D
automaticaly add the $ amount(70). If a row showed up as AA-PEN-PM, column D
would show up as $60. It is crucial that the formula looks through colum A
first, then B, and lastly C.

Your anticipated assistance is greatly appreciated.
Rick