Google Sheets - SkillSoda

How to do a Vlookup to the left in Google Sheets?

August 29, 2020 by Pankaj Sharma

VLOOKUP is a super popular formula but suffers from a major drawback. You can’t lookup data to the left! However, …

February 11, 2020 by Pankaj Sharma

How to test multiple cases without using IF Function in Google Sheet? The SWITCH function is a useful tool for …

December 19, 2019 by Pankaj Sharma

Google Sheet is one of the most used ( almost every one I know) tool now a days to excel …

November 8, 2019November 7, 2019 by Pankaj Sharma

Who doesn’t love the Vlookup function? It’s probably the most famous “advanced” excel & spreadsheet function and rightly so, because …

November 3, 2019October 31, 2019 by Pankaj Sharma

Managing attendance sheet in excel Are you stuck with managing attendance sheet in excel? Here you can find the easiest …