count Re-occurrences

Originally Posted by stevekirk

hi bryan,

project not completed

i need to be able to put a value in ai 2 depending on the size of the material i am using and if the word biesse is in the routing

the costs for the biesse are in the "cost" sheet and also the plus up depending on the material size

please see attached file

thanks
steve

Steve,

The formula for AI2 is

=AC2*Sheet2!$M$2*IF(AC2<>1,1,VLOOKUP(V2,costs!A$22:B$27,2,TRUE))

but you need to set the Lookup table as per costs!A22:B27

You can put this somewhere as a Named range, or just refer to the cells directly as shown.

I presume that you didn't want costs!e14 changed, but wanted to apply this row-by-row in Sheet1.

Cheers
----