Formula help

[mtapp2207]

I have the formula below and it works great. However I would to be able to also add the following to the formula but can't seem to get it to work. I want to use multiple lookup/match requests in one formula.

=IF($D9="Advanced",INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

I want to be able to state OR

=IF($D9="Base",INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

=IF($D9="On Site",INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

 

[Joe4]

Is this what you are looking for?

=IF(OR($D9="Base",$D9="On Site"),INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

 

[Fluff]

How about

=IF(OR($D9={"Advanced","Base","On Site"}),INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

 

[mtapp2207]

No. My mess up Sorry. I apologize

=IF($D9="Advanced",INDEX(Sheet2!$B2:$B105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

I want to be able to state OR

=IF($D9="Base",INDEX(Sheet2!$C2:$C105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

=IF($D9="On Site",INDEX(Sheet2!$D2:$D105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)))

 

[Joe4]

Maybe this then (a nested IF statement)?

=IF($D9="Base",INDEX(Sheet2!$C2:$C105,MATCH(Form!$D12,Sheet2!$A2:$A105,0)),IF($D9="On Site",INDEX(Sheet2!$D2:$D105,MATCH(Form!$D12,Sheet2!$A2:$A105,0))))

 

[Fluff]

How about

=INDEX(Sheet2!$B2:$D105,MATCH(Form!$D12,Sheet2!$A2:$A105,0),MATCH(D9,{"Advanced","Base","On Site"},0))

 

[mtapp2207]

That worked Fluff. Thank you so much

 

[Fluff]

Glad we could help & thanks for the feedback.