Formula to look for a cell phrase and add a cost

[LutonBarry]

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.

[Kenneth Hobs]

What were you trying to do? What is the string that you want to build?

[LutonBarry]

Kenneth, Not sure this reply was meant for this thread?

[LutonBarry]

Solved when I got home and cleared my head.

Add a couple of Named Ranges with the printer types and the charges in another and bingo.

=INDEX(Charge,MATCH(TRUE,ISNUMBER(SEARCH(Printer,A2)),0))