count Re-occurrences

Originally Posted by stevekirk

bryan,

thanks


what worked was (trim(right(e2,5)


hopefully that project completed ready for the next

thanks for all your help

i have learnt a lot


steve

Great to see, and good that the whole project is now complete (that was some exercise).

Good luck with your next.

---

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

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
----

thanks bryan
works great
steve