Vlookup is one of the most popular look up functions in Excel. When you need to extract data from a table based on a particular value, you can use Vlookup to do that.
Category: Smart Excel Tips
Learn to Compose and send emails from Excel using VBA
Isn’t it good if we can send emails directly from Excel? Check here to know how to send emails from Excel using VBA.
Learn to Debug Formulas in Excel
Learn to Debug Formulas in Excel Have you ever wondered how to Debug a complex Formula and fix the error quickly?? We all know how painful it is when an excel formula returns a mysterious error and we don’t know what is causing it. Assuming we have a simple formula like this =IF(D5>22000,650,IF(D5>18000,450,250)) and we […]