In previous post, we have learnt how to use VLOOKUP, but when you are
required to fight with massive data with lots of columns and row then
it will be time consume to use VLOOKUP.
But in that case, when we add one more small formula in VLOOKUP, It will
work like professional database management software, and the ingredient is
MATCH formula. You wonder how? its very easy and can be done in two
below steps.
Step. 1
(Click on Image to see)
Step. 2
(Click on Image to see)
Working smooth? Great.
No comments:
Post a Comment