I have never used it...

Report problem with this ad

Sep 14, 2017
10:22:11am

Tokolosh All-American

I have never used it...

but I am rarely doing subjective data sets. Very structured, financial data.

Report problem with this ad

Tokolosh

Bio page: Tokolosh
Joined: Jun 9, 2004
Last login: May 19, 2024
Total posts: 60,678 (5,670 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