SUBSTITUTE

How to do 2 Way Lookup in Excel - One value to lookup with two criteria using Intersect Operator

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 […]