Forum Discussion
Excel formulas change when uploaded or shared
Hello! First of all thank you for your attention 🙂 I am trying to share a .xlsx worksheet through e-mail or my drive. However, whenever I try to open it in any other computer, instead of the for...
IMHO, the simple "fix" is: do not use the new functions when the old functions would do just as well.
Change
=IF(C7="";"";XLOOKUP(C7;'ZIP Codes DB'!B4:B67;'ZIP Codes DB'!C4:C67))
to
=IF(C7="";"";VLOOKUP(C7;'ZIP Codes DB'!B4:C67, 2, 0))
Change
=IF(C2="";"";INDEX(Sheet4!E4:BB33;XMATCH(Sheet1!H8;Sheet4!A4:A33);XMATCH(C2;Sheet4!E3:BB3))
to
=IF(C2="";"";INDEX(Sheet4!E4:BB33;MATCH(Sheet1!H8;Sheet4!A4:A33,0);MATCH(C2;Sheet4!E3:BB3,0))
Aside: I would use absolute range references. It makes it easier to copy formulas. But that applies to the X-functions, as well.