Hello Everyone
hopefully someone is able and willing to help me how to solve the following problem.
NO vb is possible, only formulas can be used.
Within sheet1 in column "labor" is a field with contents in various formats and lenghts like:
[Table1!A1 = Column:Labor]
PPTM quicksearch (where PPTM is a product)
Did some research on pqcr (where pcqr is a product)
info about prodcut1234 (where prodcut 1234 is a product)
...
In Sheet2 I have a pricelist (coming from another source)
I now need to take the (text)items from column "products" from the pricelist, search if the text in column "labor" on sheet1 matches the current searchterm/entry and if there is a match put the corresponding price on sheet2 column "price".
Can that be done?
It would safe me a day or two...
Thanks for any help on this.
hopefully someone is able and willing to help me how to solve the following problem.
NO vb is possible, only formulas can be used.
Within sheet1 in column "labor" is a field with contents in various formats and lenghts like:
[Table1!A1 = Column:Labor]
PPTM quicksearch (where PPTM is a product)
Did some research on pqcr (where pcqr is a product)
info about prodcut1234 (where prodcut 1234 is a product)
...
In Sheet2 I have a pricelist (coming from another source)
I now need to take the (text)items from column "products" from the pricelist, search if the text in column "labor" on sheet1 matches the current searchterm/entry and if there is a match put the corresponding price on sheet2 column "price".
Can that be done?
It would safe me a day or two...
Thanks for any help on this.