Looking up data:What I would like to do in G

[TrainerJ]

Hi and Help.

Iam using 2003.

In Column A I have a set list of about 20 names.

I paste into Column E a list of names and in Column F data matching name (numbers).

What I would like to do in G, is display only names in Column E with the matching data in Column F...

As Iam new to excel I have no idea what to look for in the books and forums.. So sorry if this type of thing has been asked before

Jason

[Rahul Nagar]

Hi Trainer

Please attached a file with what do you want.
So that i can help you.

Rahul

[etaf]

can you give an example

From what you said (I have used - as the forum rmoves spaces )

You have
E - F
tom - 1
**** - 2
harry - 3
**** - 2
john - 67
tom - 5

So for that info above
column G would have
G
****

because Dic has the number 2 assigned to it more than once

is this correct

can you perhaps attach a sample

[TrainerJ]

How quick....

Attached is example.....

I would really like Colum D to check Colum B, for exact matches it will display Data from column D & column E in Colum F & Colum G.

[teylyn]

With your supplied data set:

F1 =VLOOKUP(B1,$D$1:$E$6,1,FALSE)

G1 =VLOOKUP(B1,$D$1:$E$6,2,FALSE)

copy down.

Edit: Added $ signs to make range absolute. Sorry for any confusion. Where is my head?! .

[TrainerJ]

Done and Dusted many thanks teylyn

You have saved me hours and hours of work....

And I understand how it's been done as well.

Quality

[teylyn]

@etaf, you can use code tags to prevent the forum software from removing spaces and indentation. Like this

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

hth

[etaf]

Vlookup will do that for you

Looks up the name
=VLOOKUP(B1,$D$1:$E$6,1,FALSE)

Looks up the number
=VLOOKUP(B1,$D$1:$E$6,2,FALSE)

We can add statements so #n/a does not appear

[etaf]

teylyn
brilliant thanks for that - happens on a lot of the forums I use
I'll go and try at techguy.org right now