'Looking Up' multiple values

T

tactps

Well-known Member

Joined

Jan 20, 2004

Messages

3,460

• May 21, 2004

• #2

Welcome

It would seem a prefect candidate for filtering:

1. Highlight the area you need (ie columns A-B).
2. From the "data" menu, click on "filter", then "autofilter".
3. From the drop-down, choose "Location 3"

Hope that this helps.

 

Upvote 0

T

Travis

Well-known Member

Joined

Feb 26, 2002

Messages

1,711

• May 21, 2004

• #3

Is it accaptable to just filter column A with Tools-->AutoFilter, or do you need to return it to a seprate column?

Edit: You beat me to it

tactps said:

It would seem a prefect candidate for filtering

Click to expand...

 

Upvote 0

Zack Barresse

MrExcel MVP

Joined

Dec 9, 2003

Messages

10,881

Office Version

1. 365
2. 2010

Platform

1. Windows
2. Mobile
3. Web

• May 21, 2004

• #4

hi there chunky_22, welcome.

maybe this link would help point you in the right direction:

http://www.mrexcel.com/board2/viewtopic.php?t=73376

or a filter like tactps' suggested.

 

Upvote 0

C

Chunky_22

Board Regular

Joined

May 19, 2004

Messages

149

• May 21, 2004

• #5

Many thanks for the quick response guys.

tactps - That would indeed do it (sorry - I should have said that Ive already used that method. My apologies)

Travis - As you say, I need to return the data to a different column / sheet etc, and also do it in bulk ie write a formula to quickly do all 670 locations.

Ive played around with Filters and SubTotal etc, but thought a fancy formula would be 'cleaner'

Best regards

C

 

Upvote 0

C

Chunky_22

Board Regular

Joined

May 19, 2004

Messages

149

• May 21, 2004

• #6

Thanks firefytr

I'll have a read thru the link U suggested, and see if my poor tired brain can sort thru it.

 

Upvote 0

T

tactps

Well-known Member

Joined

Jan 20, 2004

Messages

3,460

• May 21, 2004

• #7

Check out the post that Zack gave you and re-post if it doesn't help you.

He didn't get two stars for nothing!!!! lol

 

Upvote 0

C

Chunky_22

Board Regular

Joined

May 19, 2004

Messages

149

• May 21, 2004

• #8

Im working thru method 1 on the link you suggest, and Im not sure about this bit:

Select B1.
Activate Data|Validation.
Choose List for Allow.
Enter the following in the Source box:

=INDEX(LTable,0,1)

Click OK.

In A2 enter: Pos [ just a label, abbreviated from Position ]




What is it exactly that Im supposed to enter into A2?

I think Im doing something wrong, as am just getting errors - #NAME?

Ive created sheets identicle to the ones in the example.

 

Upvote 0

C

Chunky_22

Board Regular

Joined

May 19, 2004

Messages

149

• May 21, 2004

• #9

A-ha

Ive got it. I wasn't defining the "BigStr" thingummy.

It works like a drea, although I have absolutely no idea how, which I hate.

I may work thru it on Monday.

As usual: You guys saved the day

Many thanks, and have a great weekend one and all

 

Upvote 0