Ok,
I am trying to look at a row for a specific text string in a cell. If found, I want to look at the cell to the right for a text string. Based on the text string in the second cell I want to return a specific text string.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 64"] [/TD]
[TD="width: 87"]A[/TD]
[TD="width: 87"]B[/TD]
[TD="width: 87"]C[/TD]
[TD="width: 87"]D[/TD]
[TD="width: 87"]E[/TD]
[TD="width: 87"]F[/TD]
[TD="width: 87"]G[/TD]
[TD="width: 87"]H[/TD]
[TD="width: 83"]I[/TD]
[TD="width: 98"]J[/TD]
[TD="width: 79"]K[/TD]
1
[/td]Skill
[/td]Status
[/td]Skill
[/td]Status
[/td]Skill
[/td]Status
[/td]Skill
[/td]Status
[/td]Skill
[/td]Status
[/td]2
[/td]Start
[/td]Training
[/td]start
[/td]Stand Alone
[/td]Start
[/td]Verified
[/td]Start
[/td]Qualified
[/td]Excel
[/td]Training
[/td]3
[/td]4
[/td]5
[/td]
[TD="colspan: 2"]Cell for Return Value[/TD]
6
[/td]
[TD="width: 87"]Data Validation List for "Skills" columns[/TD]
[TD="width: 87"]Data Validation List for "Status" columns[/TD]
7
[/td]Start
[/td]Training
[/td]8
[/td]Excel
[/td]Stand Alone
[/td]9
[/td]Word
[/td]Verified
[/td]10
[/td]Qualified
[/td]11
[/td]
[/TABLE]
As in this example;
I want to look for a specific skill such as "Start" in Row 2:2. When I find "Start", I want to look to the cell to the right. If this cell is "Qualified", I want to return "Q". If not then look at the second cell for "Verified" and return "V". then on to "Stand Alone" with "S" as the returned value. And lastly "Training" with a return of "T". If none are found I want to return " ".
I am wanting the formula to work down the list from "Qualified" to "Verified" to "Stand Alone" to "Training".
Thanks in advance for your help!
XJmikeT