IF FORMULA WITH XLOOKUPS

[janema]

I am having trouble getting this IF formula to work properly while pulling XLOOKUPS.

I want it to return BLANK if the cell is blank and I want it to lookup a different sheet, if there is not data on the first sheet that it is looking up. For some reason, the blank park keeps erroring me out. This is how I am writing the formula and keep getting errors:

=IF(AM="","",IF(XLOOKUP(AM68,'LS 4.2024'!L:L,'LS 4.2024'!P:P)="",XLOOKUP(' Promotions'!AM68,'All US 4.2024'!L:L,'All US 4.2024'!P:P),XLOOKUP(AM68,'LS 4.2024'!L:L,'LS 4.2024'!P:P))

 

[StephenCrump]

Your formula is missing a closing bracket.

It would help if you told us the specific error you're getting.

Unless you've defined a name "AM", I'm guessing this should be

=IF(AM68="","",IF ....