IF/Then Question

[fleetwood417]

I'm not sure if this is possible. I'll put what I'd like to accomplish. I'd like to avoid using coding. Also if you think of an easier way, please let me know. I'm creating this log that tracks defects for my work. Each defect is associated by a number.

So, for example:

1: Miranda
2: Verification
3: Attitude

Is there a way to make an If then statement where if a Cell is blank, then nothing appears, but if you type 1, then "Miranda" appears, if you then type 1, 2, then "Miranda" and "Verification" appears, and so on.

Basically I need to be able to keep track of all of these defects and I want an easy way to do that without having to manually type them out each time. I hope this makes sense.

[alansidman]

Look at the attached workbook.

[flesem25]

I think i would try using a vlook up for most of the leg work here.

Creat a table with your combinations
1
2
1, 2
3
1,2,3
ect.

and in the column next to it put the response you want to see
Miranda
Verificaiton
Miranda/Verification or Miranda & Verificaiton
ect.

then in the cell you want the respose and do a vlooup looking up the text you type in in the table you created(be sure to hit F4 when you highlight the table to lock it in place),2,false)

If that works then just put an if statement in front of it to say if the cell is blank to return a blank if not then vlookup =if(A1="","",vlookup())

Additionally I'd used data verification to set the type in box( 1 or 1,2) as restricted to drop down values just to ensure the vlookup works.

Hope that helps.

[fleetwood417]

I have considered the VLOOKUP route, but I avoided that since the there is quite a few possibilites. There is 8 total, so you could have roughly 40,000 different combos.

[flesem25]

Ya thats just a few more than i'd like to create.

How about something like this =IF(ISERR(FIND("1",A1)),"","Miranda ")&IF(ISERR(FIND("2",A1)),"","Verificaiton ")....all they way thru your 8? Then you just have to decide how to seperate them if there are multiple values. I put a space at the end of the defect.

[Tsjallie]

Would this do what you need?
Notes are in the workbook.