Help with Formula

[Siops]

Hi guys. Could you please help me? I need help on what formula will I use if I need to find and show IF..

If Column B has a value of 1 (Column K), it will show Column L or M.

I tried the IFVlookup formula but it only shows the first match. Please help. Will greatly appreciate it. Thanks!

 

[HarryS]

try something like
in L3 as
=IF(E3=1,"absent",IF(H3=1,"leave",""))

and in m3
=IF(E3=1,A3,IF(H3=1,A3,""))

an iff statement

if "cond", "true","False"
the true or false mav be filled with more amd more if starements
each with its what to do if true or false.
for bigun draw a yes no tree diagram to get the logic right

=if(B4=7,if(k8=6,l6="b4 was 7 and k8 was 6",i ete etc etc

 

[Sal Paradise]

Assuming no values are duplicated (an agent can't be "absent" and "suspended" at the same time):
=IF(ISNA(MATCH(1,$C3:$J3,0)),"",INDEX($C$2:$J$2,1,MATCH(1,$C3:$J3,0)))

(Insert above in cell L2)

 

[Marcelo Branco]

Hi and welcome,

Not sure if i understood correctly what you are looking for.

See if this helps

Formula in L3
=IF(K3=0,"",INDEX($C$2:$J$2,MATCH(1,C3:J3,0)))
copy down

Formula in M3
=IF(K3=0,"",A3)
copy down

M.

 

[HarryS]

Sorry but I forgot to mention

copy the formula down as far as needed

 

[Siops]

Thank you guys for the reply. I think I did not clear my statement. Anyway, the screenshot is the raw data. Now lets say on Column N, I need to vlookup the Agent(Column B) with a value of 1(Column K) and will show the Column L or M.

My problem is when I use the vlookup, it will only show the first match. But what I need to get the is the first instance with a value of 1. On Column B, I have 4 "AGENT1" value.

Sep-1, AGENT1, 0(ColumnK)
Sep-2, AGENT1, 1(ColumnK)
Sep-3, AGENT1, 0(ColumnK)
Sep-4, AGENT1, 1(ColumnK)

 

[Sal Paradise]

Assuming the date is in N1, and the Agent is in O1, the following formula will find that agent for that date, and return the value in column L.

=SUMPRODUCT(($A$1:$A$65535=$N1)*($B$1:$B$65535=$O1),$L$1:$L$65535)

If this is not what you want, you need to be clearer about what you're looking for.