Adding Text Values in One Cell for IF Conditionals

[dhanna011]

So in column A, I have multiple "methods/jobs" going down in a list cell by cell. I have already created the conditional IF statements.

For example, I have created if A1 = 'calculations sheet'A1 (A1 is method number 1 text is on a data sheet on the other tab) then it will do some calculations for me. So I have done those for all of my different methods.

My only problem is, I may encounter the issue where there maybe multiple methods/jobs on a single cell.

So I am essentially trying to figure out how to tell excel to perform the calculations (these are in a row), via the method(s) shown in the first cell.

I have attached the sheet that I am working with, you can see the first box (in purple) is A1. I have two text values, but my formulas only work if one value is there.

Thank you,

[Harribone]

In L3 change the A1=Calc... to ISNUMBER(FIND('Calculation Values'!$B$2,A3)). This will check if FCIPP is in the cell then perfrom your calculation.

Breakdown
FIND("TEXT","IN")

Where "TEXT" is what you are looking for and "IN" is the cell you want to check. If found it will return a number.

ISNUMBER() if anything inside this formula is a number then it will return TRUE. FALSE returned if not.

Your formula completed in L2 should be =IF(ISNUMBER(FIND('Calculation Values'!$B$2,A3)),K3*VLOOKUP('Rehabilitation Sheet'!G3,'Calculation Values'!$A$4:$B$15,2,FALSE),0)


Hope this helps