Need help

[Diwas R Bhattarai]

Hi
I need to sort out one thing
For example
i have four option ("LEFT" "Vacation" "Final Settlement" "Working") on cell ranging from G4:G321 and when i select LEFT OR VACATION the cell i need to show show 0 other wise 30 on cell ranging from J4:J321.

I had this formula on the cell ranging J4:J321 =IF(ISNUMBER(SEARCH("Vacation",G4:G313)),"0","30")
but how to put LEFT also on that formula.

Thanks
Diwas

 

[Aladin Akyurek]

In J4 enter and copy down:

=IF(ISNUMBER(MATCH($G4,{"left","vacation"},0)),0,30)

Is this what you are after?

 

[Diwas R Bhattarai]

Yes thank you very much for the help.

 

[Aladin Akyurek]

Yes thank you very much for the help.

You are welcome.

 

[markmzz]

Another way:

=SUM(COUNTIF($G4,{"working";"final settlement"}))*30

or

=VLOOKUP($G4,{"left",0;"vacation",0;"working",30;"final settlement",30},2,0)

Markmzz