Combining IF statements

[thewiseguy]

Hi all,

I am trying to combine these 3 IF statements but having some trouble: Any help on how to do this would be GREATLY appreciated!

=IF(O4="Direct",(XLOOKUP(B4,Tbl_Proposed_Fixtures[MaskedPartNumber],Tbl_Proposed_Fixtures[Cost_Direct],XLOOKUP(B4,Tbl_Proposed_Lamps[MaskedPartNumber],Tbl_Proposed_Lamps[Cost_Direct],XLOOKUP(B4,Tbl_Proposed_Retrofit_Kits[MaskedPartNumber],Tbl_Proposed_Retrofit_Kits[Cost_Direct],XLOOKUP(B4,Tbl_Accessory[MaskedPartNumber],Tbl_Accessory[Cost_Direct],XLOOKUP(B4,Tbl_Controls[MaskedPartNumber],Tbl_Controls[Cost_Direct],XLOOKUP(B4,Tbl_Materials[MaskedPartNumber],Tbl_Materials[Cost_Direct],XLOOKUP(B4,Tbl_Recycling[MaskedPartNumber],Tbl_Recycling[Cost_Direct],XLOOKUP(B4,Tbl_Rental[MaskedPartNumber],Tbl_Rental[Cost_Direct],XLOOKUP(B4,Tbl_Labor[MaskedPartNumber],Tbl_Labor[Cost_Direct]))))))))))

IF(O4="Distribution",(XLOOKUP(B4,Tbl_Proposed_Fixtures[MaskedPartNumber],Tbl_Proposed_Fixtures[Cost_Dist],XLOOKUP(B4,Tbl_Proposed_Lamps[MaskedPartNumber],Tbl_Proposed_Lamps[Cost_Dist],XLOOKUP(B4,Tbl_Proposed_Retrofit_Kits[MaskedPartNumber],Tbl_Proposed_Retrofit_Kits[Cost_Dist],XLOOKUP(B4,Tbl_Accessory[MaskedPartNumber],Tbl_Accessory[Cost_Dist],XLOOKUP(B4,Tbl_Controls[MaskedPartNumber],Tbl_Controls[Cost_Dist],XLOOKUP(B4,Tbl_Materials[MaskedPartNumber],Tbl_Materials[Cost_Dist],XLOOKUP(B4,Tbl_Recycling[MaskedPartNumber],Tbl_Recycling[Cost_Dist],XLOOKUP(B4,Tbl_Rental[MaskedPartNumber],Tbl_Rental[Cost_Dist],XLOOKUP(B4,Tbl_Labor[MaskedPartNumber],Tbl_Labor[Cost_Dist]))))))))))))


IF(O4="Override",P4,0)

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[RobP]

glad to be of help..

thanks
Rob