Formula to apply a formula if certain cells match criteria

[NeilTrix]

I have a formula pulling prices from a list base on an index / match formula. I only need the formula to actually work if a seperate criteria is met. So i am trying to build a formula within a formula... any help appreciated.

[etaf]

=if( Cell = criteria, index/match, "" )

[NeilTrix]

Thanks, but i need it to reference a possible 5 criteria in another sheet then index match... many thanks

[etaf]

you can use a mixture of AND() and OR() to match
But i think we need a lot more detail , and a sample spreadsheet
otherwise it will take some time to get all the info , as originally

I only need the formula to actually work if a seperate criteria is met.

Now its 5

=IF ( AND ( Sheet!cell = Criteria 1 , Sheet!cell = Criteria 2 , Sheet!cell = Criteria 3 , Sheet!cell = Criteria 4 , Sheet!cell = Criteria 5) , index/match , "" )

[NeilTrix]

MAny Thanks... i found it by using If and (Or with a range selected from the column of options on the other sheet.

=IF(OR('Transfer Sheet'!B4:B8='Alto Qty'!B1),(INDEX(PRICING!$J$7:$M$150,MATCH('DIV Qty'!A3,PRICING!$A$7:$A$150,0),MATCH('Master View'!$A$1,PRICING!$J$1:$M$1,0))),"")