Vlookup or index with an Indirect added to the formula.

Sign up, and you'll be able to vote in polls. Sign up

Report problem with this ad

Sep 14, 2017
10:14:31am

Tokolosh All-American

Vlookup or index with an Indirect added to the formula.

Report problem with this ad

Tokolosh

Bio page: Tokolosh
Joined: Jun 9, 2004
Last login: Jun 10, 2024
Total posts: 60,845 (5,696 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