Hi Excellers today let's flex our formula muscles and tackle a VLOOKUP question, how to carry out a VLOOKUP over multiple worksheets in the same workbook. Suppose I have three worksheets with data sets in all of them, each corresponding to a months worth of invoice data. I want to lookup a range of invoice numbers and return the value for each of them, and they could be in any of three invoice data worksheets in my Excel workbook. Let's do a quick recap of the VLOOKUP Syntax The Syntax … [Read more...]

## Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula

Hello Excellers and welcome to another #formulafriday today let's look at a request I have had from a reader, and that is to insert the file path and name of the file in a cell on the front of a workbook (or the first sheet). This actually is a really useful piece of information, to know exactly where your file is saved either locally or in a network location. I use this a lot as would have a need to know if my files are locally stored or on a shared drive using multiple report folders on a … [Read more...]

## Formula Friday – Top 3 Reasons Not To Use Hard Coding In Excel Formulas

Hi Excellers, it is time for some more formula fun on #formulafriday. Today I want to share with you my Top 3 Reasons Not To Use Hard Coding In Excel Formulas If you want see see all of the blog posts in the #formulafriday series then you can click on this page right here. If you want MORE Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. If you want to see all of the blog posts … [Read more...]

## Formula Friday – Calculate The Date Of The Nth Weekday Of The Month

Hello Excellers welcome to more #formulafriday fun, today let's look at a query that is a actually a widely used calculation for a lot of different scenarios- calculating a date of a certain weekday in every month. For example- Calculate the date if you get paid on the second Tuesday of every month I calculate the date of the issue of my Newsletter which is issued the First Tuesday of every month A meeting which occurs on the last Friday of every month The date of Thanksgiving in … [Read more...]

## Formula Friday – How To Make An Exact Copy OF An Excel Formula

Hello it is #formulafriday again, today let's look at how to make an EXACT copy of an Excel Formula. What do I mean by that?. Well, when you copy of formula and paste it to a new range of cells, like another location in your worksheet or workbook, well, Excel is really helpful and adjusts the formula. For example - =SUM(A1:A4) is copied to the Column C then the formula is adjusted accordingly to =SUM(C1:C4) If you do not want this helpful assumption by Excel then it is easy … [Read more...]

- 1
- 2
- 3
- …
- 5
- Next Page »