khalid79m
04-22-2009, 04:59 AM
I am new to IF Case so all help would be appreciated , also im not sure this is the best statement for what I need to do :(
I have a range named AUDITOR , in that range for "John" I need to look at the named range CATEGORY and if it contains either A , D , N then put in "PASS" in the Range ONE_CALL otherwise "FAIL"
I have a range named AUDITOR , in that range for "Michael" I need to look at the named range CATEGORY and if it contains either A , Z , AQ , M then put in "PASS" in the Range ONE_CALL otherwise "FAIL"
AND So on..
the ranges are columns for example
Auditor | Category | One Call
so for example
John |A | Pass
John |ZZ| Fail
John |N | Pass
Michael| A | Pass
Michael | XX | Fail
Or should I use a lookup table.? but how would I get that to work
Confused.Com :)
I have a range named AUDITOR , in that range for "John" I need to look at the named range CATEGORY and if it contains either A , D , N then put in "PASS" in the Range ONE_CALL otherwise "FAIL"
I have a range named AUDITOR , in that range for "Michael" I need to look at the named range CATEGORY and if it contains either A , Z , AQ , M then put in "PASS" in the Range ONE_CALL otherwise "FAIL"
AND So on..
the ranges are columns for example
Auditor | Category | One Call
so for example
John |A | Pass
John |ZZ| Fail
John |N | Pass
Michael| A | Pass
Michael | XX | Fail
Or should I use a lookup table.? but how would I get that to work
Confused.Com :)