Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago
Solved

Vlookup and calculation

Hello, I'm struggling with following: I have two tables and I need to calculate the difference between amounts in two columns (one in each table), based on the FAM line (4+ digit number).   Coul...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi KatkaS ,

Is the problem solved?

 

Best Regards,

Icey

  • KatkaS's avatar
    KatkaS
    Icon for Post Patron rankPost Patron
    6 years ago

    Hello Icey,

    I'm really sorry to take your time, your solution looks great, but it isn't working for me..

     

    I Added Custom Column as per your advice, but I'm getting below error:

     

     

     

     

     

     

    When I added the columnm there was no syntax error (but I had to remove ' ' signes and doubled &s, they were giving errors....), here how it looks like:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Do you think you could still have a look in this? Thank you!

     

      • KatkaS's avatar
        KatkaS
        Icon for Post Patron rankPost Patron
        6 years ago

        Thank you so much for your help, Icey!!!!!

        It worked for me and the links you sent last time are very useful too!!!