Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
175
Views
Topic starter
Hello,
I'm noticing that the Vlookup is returning the 'income' for my category type but not the 'expense' for my category type even though they are in the same table and column and referencing the correct column index.
I am using Excel 2016 on PC.
Thank you for your help
Posted : 25/08/2023 5:00 pm
Hi Ayanna,
VLOOKUP only looks up the first column in the 'lookup_array'. It works for Salary because you have Salary in both the Sub-category and the Category columns of the lookup_array.
You need to change the formula to:
=VLOOKUP([@Category],TblDV[[Category]:[Category Type]],2,FALSE)
Mynda
Posted : 25/08/2023 8:48 pm
