Vlookup function with if statement possibility?

[Lupirion]

Hi every one. Im new here.

I have a question if its possible. i work with excel every day but i'm basically a noob
Here is the situation i have. i have to go through a list of a lot of articles to take out the information from it ( if it is pass fail or pending)
i dont wanna keep going through every single box to pick fail, pending or pass.

Is there a way to use Vlookup or any other way to tell excel:
"ok look at box 1 if you see fail in any of the items then show me just fail if not then pending if not then pass etc"

Article	Article's components	Status
Box 1	item 1	pass
Box 1	item 2	fail
Box 1	item 3	pending
Box 1	item 4	fail
Box 2	item 1	pass
Box 2	item 2	fail
Box 3	item 1	pass
Box 3	item 2	pass
Box 3	item 3	pending

<tbody>
</tbody>

i might be busy and i might forget to reply to you guys sorry if that happens.

Thank you for your help
Have a nice day

 

[AlanY]

try

Book1
	A	B	C	D	E	F
1	Article	Article's components	Status
2	Box 1	item 1	pass		Box 1	fail
3	Box 1	item 2	fail		Box 2	fail
4	Box 1	item 3	pending		Box 3	pending
5	Box 1	item 4	fail
6	Box 2	item 1	pass
7	Box 2	item 2	fail
8	Box 3	item 1	pass
9	Box 3	item 2	pass
10	Box 3	item 3	pending
Sheet3

Cell Formulas
Range	Formula
F2	=IF(COUNTIFS($A$2:$A$10,$E2,$C$2:$C$10,"fail")>0,"fail",IF(COUNTIFS($A$2:$A$10,$E$2,$C$2:$C$10,"pending")>0,"pending","pass"))

 

[Lupirion]

OMG that is perfect :D exactly what i needed

Thank you Alan

I presume i can add more countifs? say if i have not applicable or not relevant etc. the same way?

thanks again

 

[AlanY]

you're welcome.

ans yes you can add more criteria i countifs() as needed

 

[Lupirion]

Awesome

You are a life saver.