INDEX MATCH > VLOOKUP (excel smack!)

Sign up, and you'll be able to ignore users whose posts you don't want to see. Sign up

Report problem with this ad

Sep 14, 2017
10:29:29am

Banjo All-American

INDEX MATCH > VLOOKUP (excel smack!)

Report problem with this ad

Banjo

Bio page: Banjo
Joined: Aug 9, 2010
Last login: Jun 9, 2024
Total posts: 4,668 (64 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