Use VLOOKUP formula without an exact match….to calculate sales commission
Sometimes you do not actually want an exact match on a VLOOKUP....really?.... I know most times when using VLOOKUPS we do, want that exact match, but what...
Posts by Barbara
Hi Excellers yet another Friday so that means Formula Time!....yay....so today...something that I have been looking at recently as asked by one of my Newsletter subscribers- that is--...
Hey, Excellers time for more Friday Formula Fun. Today let's look at how to deal with the #N/A error we get when no match is found when using VLOOKUP. It's a handy error as it tells us when there...
Happy Friday everyone- time for formula fun. Today let's look at adding a column of values so they add cumulatively or sometimes known as a running total. As ever let's take an example. I have...
Hey all, Friday Formula Time Again....today let's look at how to easily keep track of what your formulas actually mean. When you are creating a formula or many formulas as is usually the case in a...
Formula Friday- Calculate How Many Days Until The End Of A Sales Campaign
Hey all, and it's time for another Formula Friday.... Today I want to share with you a query recently sent to me by Daniel. He wanted to calculate how many days he had left in a campaign. ...