Excel Tips
Combine Formulas into a Mega-Formula »
April 27, 2022
When I need to build a complex calculation, I sometimes need to build several intermediate formulas to help figure out the problem. When these formulas are all working, can I combine the logic from the intermediate formulas into a single formula?
April 26, 2022
I need to do a lookup where I find the product ID down the left side and the month from the top row. I need to return the intersection of that row and column.
Return the Next Larger Value in a Lookup »
April 25, 2022
I am using a lookup table to calculate a late-payment penalty. As soon as a customer is 1 day late, they are charged the penalty for the first month. When they reach 31 days late, they pay for two months. After 60 days late, they are billed for half months.
April 22, 2022
I have to do thousands of VLOOKUPs and they are taking almost a minute every time that I recalculate the worksheet.
April 21, 2022
I have to do twelve columns of VLOOKUP. The lookup table is large. The data set is even larger. It is taking forever to calculate.
April 20, 2022
The lookup table is maintained by another department. They built it with the price to the left of the item number. Can I specify -1 as the third term of the VLOOKUP to indicate that I want a value to the left of the key field?
You Already Know MATCH, Really! »
April 18, 2022
The author of this book is jamming two functions that I have NEVER heard of on the same page. He is starting to hack me off.
Copy a VLOOKUP Across Many Columns »
April 15, 2022
I’ve entered a VLOOKUP for January. I need to copy the formula across eleven additional columns.
Your Lookup Table Can Go Across »
April 13, 2022
Someone built this lookup table going across the worksheet. How can I use VLOOKUP?