PDA

View Full Version : Solved: IF CASE



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 :)

mdmackillop
04-22-2009, 05:01 AM
Posting a sample workbook would assist.

khalid79m
05-19-2009, 05:31 AM
Sorry for late reply been off ill, i managed to work it out aswell, thanks .. for your help

mdmackillop
05-19-2009, 05:47 AM
Can you post your solution for the benefit of others who read your question?