Techy Stuff
Follow
Find tag "VLookup"
14.2K views | +2 today
Techy Stuff
Interesting tech links for the Geeks and wannabees
Curated by Patty Ball
Your new post is loading...
Your new post is loading...
Scooped by Patty Ball
Scoop.it!

What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK]

What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK] | Techy Stuff | Scoop.it
I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It ...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

vlookup(), match() and offset() - explained in plain english [spreadcheats]

vlookup(), match() and offset() - explained in plain english [spreadcheats] | Techy Stuff | Scoop.it
VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understandin...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

Comprehensive Guide to VLOOKUP & Other Lookup Formulas

Comprehensive Guide to VLOOKUP & Other Lookup Formulas | Techy Stuff | Scoop.it
This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on ...,

What is VLOOKUP Formula...
more...
No comment yet.
Scooped by Patty Ball
Scoop.it!

How to Lookup Values to Left?

How to Lookup Values to Left? | Techy Stuff | Scoop.it
SituationThere is no argument that VLOOKUP is a beautiful & useful formula. But it suffers from one nagging limitation. It cannot go left.Let me explain, Imagine you have data like below. Now, ...
more...
No comment yet.