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
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!!!