Tag: vlookup

Excel VLOOKUP all variations

Excel VLOOKUP is a very common and popular function. It is now superseded with the XLOOKUP function. Still it’s popularity is not going down. This video (in English and Hindi)

Read »
Custom Date Grouping using VLOOKUP

Date grouping using custom quarters or periods can be done using VLOOKUP. This is a very powerful and quick method for creating reports. Estimated reading time 7 min Potential time

Read »
Use PowerPivot instead of VLOOKUP

This time I wanted to try a new style of writing. I created a presentation instead of the usual document like style. Download presentation and view Download the presentation (300kb)

Read »