PDA

View Full Version : [SOLVED] Formula to look for a cell phrase and add a cost



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.

Kenneth Hobs
09-30-2019, 08:36 AM
What were you trying to do? What is the string that you want to build?

LutonBarry
09-30-2019, 09:30 AM
Kenneth, Not sure this reply was meant for this thread?

LutonBarry
10-01-2019, 02:37 AM
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))