# Vlookup function with if statement possibility?

#### Lupirion

##### New Member
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.

Have a nice day

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
try

Book1
ABCDEF
1ArticleArticle's componentsStatus
2Box 1item 1passBox 1fail
3Box 1item 2failBox 2fail
4Box 1item 3pendingBox 3pending
5Box 1item 4fail
6Box 2item 1pass
7Box 2item 2fail
8Box 3item 1pass
9Box 3item 2pass
10Box 3item 3pending
Sheet3
Cell Formulas
RangeFormula
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"))

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

you're welcome.

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

Awesome

You are a life saver.

Replies
0
Views
125
Replies
3
Views
344
Replies
1
Views
87
Replies
7
Views
355
Replies
0
Views
170

1,196,516
Messages
6,015,678
Members
441,915
Latest member
sm Hussaini

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back