Speaking of Vlookup - is there any use for the approximate match?

Report problem with this ad

Sep 14, 2017
10:21:08am

Skeptical Optimist All-American

Speaking of Vlookup - is there any use for the approximate match?

That seems pretty useless when you have a structured dataset.

Report problem with this ad

Skeptical Optimist

Previous username: workindev
Bio page: Skeptical Optimist
Joined: Aug 2, 2006
Last login: May 18, 2024
Total posts: 79,311 (4,250 FO)

Report problem with this ad

Messages

Author

Time

Excel question: pull data from one list to specific items on another

9/14/17 10:11am

Vlookup or index with an Indirect added to the formula.

Tokolosh

9/14/17 10:14am

Speaking of Vlookup - is there any use for the approximate match?

Skeptical Optimist

9/14/17 10:21am

I have never used it...

Tokolosh

9/14/17 10:22am

I use it on occasion...for banding data together by ranges

jimbo

9/14/17 10:33am

So...

Tokolosh

9/14/17 10:15am

I do this with a Vlookup function. You have to set it up to search your parts

9/14/17 10:17am

Awesome. Thanks, all, worked like a charm.

9/14/17 10:28am

INDEX MATCH > VLOOKUP (excel smack!)

Banjo

9/14/17 10:29am

^^^ this, and I'm persecuted unfairly for this opinion

kos

9/14/17 10:31am

RE: ^^^ this, and I'm persecuted unfairly for this opinion

Ulysses14

9/14/17 10:59am

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad