excel problem

world cup willy · May 23rd, 2002, 03:08 PM

if i put a list of names in rowc and a list of names in rowb can i put any names that
match in rowc.i am new to excel and just wondered if this was possible.

PaddyD · May 23rd, 2002, 03:20 PM

Welcome, Willy!

All things are possible in the end, but:

1) You've already got a list of names in row c - was that a typo? do you want to put matched names in row d??
2) What do you mean by matched? Where the values on the same row are equal, or just if the same same turns up in both columns?
3) Can you have more than one match, or wll there only be one instance of each name per row?

Clarify a bit & I'm sure a solution will turn up...

Paddy

world cup willy · May 27th, 2002, 02:37 AM

sorry paddy it was a type error,ill try again.
if i have a list of names in columnA and list of names in columnB can i put in columnC
the names that appear in both A and B column,s .

Ben · May 27th, 2002, 05:29 AM

Worldcupwilly

If you just want to match every instance where an entry in column b matches an entry in column a then a simple vlookup should do

However, this will return #N/A if the entry in column b does not appear anywhere in Column A. I am sure people out there with a lot more knowledge than me can offer a better solution (e.g. to only return an entry in column C once if there is more than one match)

Assuming your names are in columns A1:A10 and B1:B10 enter the following formula in C1 and drag down to C10

=VLOOKUP(B1,$A$1:$A$11,1,FALSE)

Hope it does the trick

Ben · May 27th, 2002, 05:35 AM

Willy

Sorry the assumption above should be that entries are in A1:A11 and B1:B11

PaddyD · May 27th, 2002, 03:08 PM

Willy,

Or have a look at the following for a bit more detail:

http://www.mrexcel.com/board/viewtop...9570&forum=2&3

Paddy

Chris Davison · May 27th, 2002, 04:09 PM

an excellent choice Paddy

adjusting this thread for my suggestion on the earlier link, we'd just need to change the countif criteria to >=2 rather than =1 ie to capture duplicates assuming there weren't any in the original data

world cup willy · May 28th, 2002, 02:21 AM

thanks for your help .i hope to use this from now on----cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 03:08 PM	#1
world cup willy New Member Join Date: May 2002 Posts: 4	if i put a list of names in rowc and a list of names in rowb can i put any names that match in rowc.i am new to excel and just wondered if this was possible.

May 23rd, 2002, 03:20 PM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Welcome, Willy! All things are possible in the end, but: 1) You've already got a list of names in row c - was that a typo? do you want to put matched names in row d?? 2) What do you mean by matched? Where the values on the same row are equal, or just if the same same turns up in both columns? 3) Can you have more than one match, or wll there only be one instance of each name per row? Clarify a bit & I'm sure a solution will turn up... Paddy

May 27th, 2002, 02:37 AM	#3
world cup willy New Member Join Date: May 2002 Posts: 4	sorry paddy it was a type error,ill try again. if i have a list of names in columnA and list of names in columnB can i put in columnC the names that appear in both A and B column,s .

May 27th, 2002, 05:29 AM	#4
Ben New Member Join Date: May 2002 Posts: 37	Worldcupwilly If you just want to match every instance where an entry in column b matches an entry in column a then a simple vlookup should do However, this will return #N/A if the entry in column b does not appear anywhere in Column A. I am sure people out there with a lot more knowledge than me can offer a better solution (e.g. to only return an entry in column C once if there is more than one match) Assuming your names are in columns A1:A10 and B1:B10 enter the following formula in C1 and drag down to C10 =VLOOKUP(B1,$A$1:$A$11,1,FALSE) Hope it does the trick

May 27th, 2002, 05:35 AM	#5
Ben New Member Join Date: May 2002 Posts: 37	Willy Sorry the assumption above should be that entries are in A1:A11 and B1:B11

May 27th, 2002, 03:08 PM	#6
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Willy, Or have a look at the following for a bit more detail: http://www.mrexcel.com/board/viewtop...9570&forum=2&3 Paddy

May 27th, 2002, 04:09 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	an excellent choice Paddy adjusting this thread for my suggestion on the earlier link, we'd just need to change the countif criteria to >=2 rather than =1 ie to capture duplicates assuming there weren't any in the original data

May 28th, 2002, 02:21 AM	#8
world cup willy New Member Join Date: May 2002 Posts: 4	thanks for your help .i hope to use this from now on----cheers