excel bloody help before I kill someone :(

[TdC]

I'm poo at excel. Please help me.

This is the deal: I want to select a range out of another range based on criteria that I have in a list. That selection I want to appear in the sheet at some place.

the range looks like this:

name     some info     more info     other info     different info
name     some info     more info     other info     different info
name     some info     more info     other info     different info
etc

the list I have looks like this:

nameA
nameB
nameC
etc

I want to select all instances in the range where col "name" exists in list "list" and copy that to some place in the sheet without using VB if possible.


Help

 

[Jupitus]

Vlookup will do this Teedles, I think... I'll do you a sample hold on....

 

[TdC]

vlookup is just giving me #VALUE Jup am I forgetting something?

 

[Jupitus]

Like this?

 

[TdC]

that looks about right mate! where do I send the classy hooker and pizzas?

 

[Jupitus]

This is how I set this up

1) Select cells containing the data, then 'Insert','Name','Define' and name the area 'Data_Table'

Cell B13 contains:

"=VLOOKUP(A13,Data_Table,4,FALSE)"

A13 is the name to lookup in the data table
Data_table is whatever name you defined as the area with data in (duh)
4 represents the column number to return.
False specifies an exact match

If you are getting errors using vlookup, then make sure you are only trying to use it with cells of type 'text'. Also, either the data table or the list for looking up NEED to be in alphabetical order....

I'll keep the hoookers on my account for now, fella

 

[TdC]

it all works now! cheers Jup, I wasn't aware that I could choose different columns to be returned!

 

[babs]

Vlookup is my lifeblood at work