complex "if" statements

[VickyL1807]

I'm working on Win.7 with multiple sheet Excel 2010 version which includes lookup tables.

I need the result of several cells to be returned in one specific location in a multi-form sheet based on a criteria that returns one "code" for a specific criteria and another "code" for the remaining criteria.

I have extracted a section from the spreadsheet and attached.

Hope the "Brains Trust" can help.

[#2]

@VickyL1807 

Not entirely sure what you are trying to achieve but perhaps the attached workbook has the solution you need. I used VLOOKUP rather than LOOKUP and expanded the table with the values a bit to avoid nested IF statements. 

D4 has a formula that gives you the end result for what (I think) you asked for. If not, it might lead you into the right direction.

[#3]

@VickyL1807 

Not sure I understood the logic correctly, as variant

=IF(C2="PIECES",IF($B$6<=22.5,"FPCS","MPCS"),$A$7&LOOKUP($B$6,$A$10:$A$16,$C$10:$C$16))