If with multiple criteria

[raccoon588]

Id like to write a formula that has an if with more then one criteria but nothing seems to be working. =if(n1="ablation", i want to look in a table for two criteria and return the amount in column H.

 

[joshman108]

=if(and(n1="ablation",othercritera),h1,"")

This will work. Change othercritea to be whatever you want

 

[JoeMo]

You can use AND or OR depending on whether both criteria must be met, or just one of the two, respectively.

=IF(AND(n1="ablation",o1 = "something else"),H1,"")

 

[raccoon588]

I think i need to use a vlookup nested inside an IF. can you have multiple criteria for a vlookup?

 

[joshman108]

Not to my knowledge but you can for Match, inside of index/match like this:

=INDEX(MATCH(CELL1&CELL2,RANGE1&RANGE2,0))

if you give data we can help write the formula so it works, if you need help

 

[raccoon588]

Month

Deck

Resource Name

OutputSum

GoalSum

Goal%

TheoSum

OEE%

MASTER

Ablation

10/1/2019

HIL-9007

HIL-9007-FIM

380441

423262

89.88%

536131

70.96%

OEE

10/1/2019

HIL-Ablation

HIL-Ablation-Laser

173949

308741

56.34%

353882

49.15%

10/1/2019

HIL-9007-FIM

10/1/2019

HIL-Coating

HIL-Coating-QRQC

635222

741375

85.68%

892736

71.15%

Nov

#ref !

10/1/2019

HIL-H13Assembly

HIL-H13Assembly-FIM

391167

537350

72.80%

661274

59.15%

Dec

#ref !

10/1/2019

HIL-H13Capsule

HIL-H13Capsule-RingMo

465458

413297

112.62%

514479

90.47%

Jan

#ref !

10/1/2019

HIL-H8

HIL-H8-Ager

425523

529793

80.32%

721731

58.96%

Feb

#ref !

Mar

#ref !

Apr

#ref !

May

#ref !

Jun

#ref !

Jul

#ref !

Aug

#ref !

Sep

#ref !

<colgroup><col><col><col><col><col><col><col><col><col span="5"><col><col><col></colgroup><tbody>
</tbody>

This is some of my data. Will be adding months as they close. over to the right i would like to be able to change the data based on the machine. ablation is an example of one of the machines i need the OEE % number to show in the cell that has the #ref .