Mac user challenged with getting functions to work in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2388407%22%20slang%3D%22en-US%22%3EMac%20user%20challenged%20with%20getting%20functions%20to%20work%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388407%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20constant%20challenge%20in%20getting%20VLookup%20or%20Concatenate%20to%20work%20on%20a%20Mac%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20any%20particular%20tips%20or%20tricks%20to%20get%20it%20to%20work%20the%20first%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tend%20to%20take%20the%20code%20from%20someone%20on%20a%20PC%2C%20and%20then%20paste%20it%20to%20get%20it%20to%20work.%20After%20having%20exhausted%20all%20the%20tips%20and%20tricks%20provided%20by%20others%2C%20and%20your%20tools%20to%20help%20in%20building%20the%20formulas%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20ensure%20these%20functions%20deliver%20the%20needed%20information%20on%20the%20first%20try%3F%26nbsp%3B%20I%20am%20no%20stranger%20to%20working%20in%20Excel.%20Just%20does%20not%20work%20on%20a%20Mac.%26nbsp%3B%20Always%20worked%20on%20a%20PC%20for%20me%2C%20but%20since%20I%20changed%20over%20to%20a%20MAC%20this%20is%20a%20non-stop%20challenge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2388407%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2388711%22%20slang%3D%22en-US%22%3ERe%3A%20Mac%20user%20challenged%20with%20getting%20functions%20to%20work%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388711%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1063994%22%20target%3D%22_blank%22%3E%40Karen_Qamar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormulas%20should%20work%20the%20same%20way%20on%20a%20Mac%20as%20on%20Windows.%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20a%20different%20decimal%20separator%3F%3C%2FP%3E%0A%3CP%3EOr%20do%20you%20use%20a%20different%20version%20of%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a constant challenge in getting VLookup or Concatenate to work on a Mac in Excel.

 

Are there any particular tips or tricks to get it to work the first time.

 

I tend to take the code from someone on a PC, and then paste it to get it to work. After having exhausted all the tips and tricks provided by others, and your tools to help in building the formulas correctly.

 

What is the best way to ensure these functions deliver the needed information on the first try?  I am no stranger to working in Excel. Just does not work on a Mac.  Always worked on a PC for me, but since I changed over to a MAC this is a non-stop challenge.

 

1 Reply

@Karen_Qamar 

Formulas should work the same way on a Mac as on Windows.

Do you have a different decimal separator?

Or do you use a different version of Excel?