Awesome. Thanks, all, worked like a charm.

Report problem with this ad

Sep 14, 2017
10:28:11am

LeftOfNormal All-American

Awesome. Thanks, all, worked like a charm.

Report problem with this ad

LeftOfNormal

Bio page: LeftOfNormal
Joined: May 31, 2010
Last login: May 18, 2024
Total posts: 32,913 (1,695 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