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 ,

 

If you don't mind, please give me some data sample.


Best Regards
Icey

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

 So in my example above I search for the amounts to compare linked to FAM line (column C) and number in column B (Balance sheet). It must be based on the Operational company (CZC in this case, but there are many more). FAM lines are the same for all the companies.

 

I hope I'm clearer now..