Blogs about: Vlookup
Featured Blog
Cell value from a grid
While we can use vlookup or hlookup to return a cell value in a particular row or column. Is there a way we can lookup from both row and column to return a particular value from a cell in a grid? Cons… more →
Useful Excel Tips
How To Calculate Quantity Price Breaks
Seth David wrote 2 weeks ago: WATCH THE WEBCAST (VIDEO) If you are in the business of selling products then you will find this tut … more →
Nuts and Bolts: Creating a vlookup formula
njconner wrote 2 weeks ago: So all the talk about how powerful vlookup is won’t do you, the user, any good without knowing how i … more →
Meet your new best friend (vlookup Series, Part 1)
njconner wrote 2 weeks ago: If excel were to ditch all of it’s functions tomorrow, and users only got to keep their 5 favorites, … more →
TIPS: Corrupt Excel Files and Prevention
— 1 comment
anthonli wrote 1 month ago: I’m sure some of you would have experienced at some point Excel showing the following error message: … more →
Using functions in Excel
gaganmand wrote 1 month ago: Excel is great program once you learn how to use it. It can very stressful when you cannot understan … more →
How to track your sales in MS Excel
Seth David wrote 1 month ago: Click here to watch the web cast: How to track your sales in MS Excel Some of us have small business … more →
Spreadsheet Modelling- A Reminder!
— 2 comments
Jeff Herman wrote 2 months ago: Blue-Plate consultants often find themselves advising on or building spreadsheet models on behalf of … more →
Save hours
kmdavison wrote 2 months ago: Over the last 10 years I have seen many people come into my classrooms for training. They come in f … more →
Timesheets - Conditional Formatting, Vlookup, & Weekday formula
Seth David wrote 4 months ago: MS excel’s conditional formatting feature allows you to highlight data based on certain criter … more →
When Excel Beats Access
— 3 comments
Rich Parma wrote 4 months ago: I was late to realize the power of Excel. Why? Mostly because I learned Access first. I thought that … more →
Cell value from a grid
anupagarwal wrote 5 months ago: While we can use vlookup or hlookup to return a cell value in a particular row or column. Is there a … more →
First, Last, Min, Max for a particular value in an array
— 1 comment
anupagarwal wrote 6 months ago: Consider a set-up where 4 users randomly appear for a test. Their scores are recorded in the order i … more →
Lookup_value as array
anupagarwal wrote 6 months ago: lookup_value as array, why lookup over vlookup, multiple lookup_value in single lookup function, sum … more →
Converting numbers to words
— 1 comment
anupagarwal wrote 6 months ago: How do we convert numbers to words. Especially useful if you are writing cheques (checks) through pr … more →
Extract and sum vlookup results
— 1 comment
anupagarwal wrote 6 months ago: multiple vlookup, sum(vlookup), sum vlookup results in a single formula Consider the problem as belo … more →
Lookup to the left
anupagarwal wrote 7 months ago: For looking up through vlookup, the value to be returned needs to be to the right of lookup_value. H … more →
Vlookup - col_index_num
anupagarwal wrote 7 months ago: A quick trick for people who often use vlookup. Often when the table array is large, calculating the … more →
Troubleshooting vlookup
anupagarwal wrote 7 months ago: In this post I have listed issues that people often face while using vlookup To begin with, here is … more →
Multiple extraction through vlookup
— 2 comments
anupagarwal wrote 7 months ago: The problem here is extraction of multiple results from a two column array through a vlookup The d … more →
