LutonBarry
09-30-2019, 06:09 AM
Folks,
I should know this but I cannot get to grips with it.
The attached spreadsheet has different printer types in col A and I need a formula to look in the cells in coloumn A and then place cost in Column B depending on the type of printer Column A contains. The printer type forms part of a long text string and the position of th eprinter type within that is inconsistent.
This could either be a formula to reference the suggested costs in ColumI or a formula that allows us to enter the cost as part of the formula.
I should know this but I cannot get to grips with it.
The attached spreadsheet has different printer types in col A and I need a formula to look in the cells in coloumn A and then place cost in Column B depending on the type of printer Column A contains. The printer type forms part of a long text string and the position of th eprinter type within that is inconsistent.
This could either be a formula to reference the suggested costs in ColumI or a formula that allows us to enter the cost as part of the formula.