Removing FALSE from IF statement

[thewiseguy]

Can't seem to get the FALSE to disappear - any ideas?

=IFERROR(IF(C22="Fixture",XLOOKUP(A22,Table_Fixtures[MaskedPartNumber],Table_Fixtures[PartNumber]),IF(C22="Lamp",XLOOKUP(A22,Table_Lamps[Lamp],Table_Lamps[PartNumber]), IF(C22="Accessory",XLOOKUP(A22,Table_Accessories[MaskedPartNumber],Table_Accessories[PartNumber]),IF(C22="Control",XLOOKUP(A22,Table_Controls[MaskedPartNumber],Table_Controls[PartNumber]))))),"")

A22 is empty
B22 is empty but contains a formula
c22 is empty but contains a formula

Any help is greatly appreciated!

 

[Fluff]

How about

=IFERROR(IF(C22="Fixture",XLOOKUP(A22,Table_Fixtures[MaskedPartNumber],Table_Fixtures[PartNumber]),IF(C22="Lamp",XLOOKUP(A22,Table_Lamps[Lamp],Table_Lamps[PartNumber]), IF(C22="Accessory",XLOOKUP(A22,Table_Accessories[MaskedPartNumber],Table_Accessories[PartNumber]),IF(C22="Control",XLOOKUP(A22,Table_Controls[MaskedPartNumber],Table_Controls[PartNumber],""))))))

 

[thewiseguy]

it's telling me too few arguments?

 

[Fluff]

Missed you had the iferror, which is not needed with xlookup

=IF(C22="Fixture",XLOOKUP(A22,Table_Fixtures[MaskedPartNumber],Table_Fixtures[PartNumber],""),IF(C22="Lamp",XLOOKUP(A22,Table_Lamps[Lamp],Table_Lamps[PartNumber],""), IF(C22="Accessory",XLOOKUP(A22,Table_Accessories[MaskedPartNumber],Table_Accessories[PartNumber],""),IF(C22="Control",XLOOKUP(A22,Table_Controls[MaskedPartNumber],Table_Controls[PartNumber],""),""))))

 

[thewiseguy]

Didnt realize that - thank you

 

[Fluff]

You're welcome & thanks for the feedback.