How to do 2 Way Lookup in Excel - One value to lookup with two criteria using Intersect Operator
I can safely assume that almost everyone knows about LOOKUP formulas or precisely VLOOKUP. That is probably because sights and sounds of Excel don’t go without shouts and screams of lookup formulas. Learning Excel and not learning lookup formulas is like learning Japanese and not learning how to use chop sticks! So if you are […]
![How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]](../../wp-content/uploads/2012/09/excel-page-featured-image-150x150.png)
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel is just another program with ability to store information and doing simple maths. In a nutshell functions made a spreadsheet program that can really excel at data. Functions are like ready […]
