Forum Discussion
Need to lookup each employee Trained & Certified data sheets and populate YES or NO
Dear All, I am posting this from 2016 version. I need formula help for both 2016 version and Office 365 versions. Problem: I have 2 tabs ( Trained data & Certified Data of employees) in two ...
Vijayvr You tagged your post with Powe BI, but perhaps you are willing to use Power Query (PQ) in stead and forget about regular Excel formulas.
The attached file contains a PQ solution with a pivot table. You don't have the Yes/No, but it looks a lot cleaner in my opinion. Should work in all Excel versions after 2013. See it it works for you.
- Thank youRiny
