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)))
=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)))