Match?

LoriD · Apr 15th, 2002, 12:01 PM

I have a list of Departments and names on Sheet2.
On Sheet1, I want to be able to key the department and have the names pop up.
Is there a way to do this? I tried "Match", but it will only return a number.

Brian from Maui · Apr 15th, 2002, 12:12 PM

LoriD

Try VLOOKUP

http://www.mrexcel.com/board/viewtop...5192&forum=2&5

[ This Message was edited by: Brian from Maui on 2002-04-15 11:14 ]

Asala42 · Apr 15th, 2002, 12:13 PM

Hiya,

Sounds like you could have had a Vlookup.

Ricky Morris · Apr 15th, 2002, 12:13 PM

Try using vlookup

=vlookup(DeptNo,Table,ColumnNumber)

Al Chara · Apr 15th, 2002, 12:17 PM

I think your problem is better suited for vlookup:

On Sheet1, enter in your department to match in Cell A1 and place the following formula in B1: =VLOOKUP(A1,Sheet2!A:B,2)
On Sheet2, your data should be organized as department in column A and name in column B.

Mark O'Brien · Apr 15th, 2002, 12:39 PM

How about VLookup?

Sorry, couldn't resist.

LoriD · Apr 15th, 2002, 12:47 PM

Thanks all, but I think I'll try using VLookup.

Mark O'Brien · Apr 15th, 2002, 12:48 PM

Good idea. I wish someone had thought of that.

Apr 15th, 2002, 12:13 PM	#4
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try using vlookup =vlookup(DeptNo,Table,ColumnNumber) __________________ It's never too late to learn something new. Ricky

Apr 15th, 2002, 12:17 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I think your problem is better suited for vlookup: On Sheet1, enter in your department to match in Cell A1 and place the following formula in B1: =VLOOKUP(A1,Sheet2!A:B,2) On Sheet2, your data should be organized as department in column A and name in column B. __________________ Kind regards, Al Chara

Apr 15th, 2002, 12:39 PM	#6
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	How about VLookup? Sorry, couldn't resist. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 15th, 2002, 12:48 PM	#8
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Good idea. I wish someone had thought of that. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 15th, 2002, 12:01 PM	#1
LoriD Board Regular Join Date: Apr 2002 Location: Rhode Island Posts: 128	I have a list of Departments and names on Sheet2. On Sheet1, I want to be able to key the department and have the names pop up. Is there a way to do this? I tried "Match", but it will only return a number.

Apr 15th, 2002, 12:12 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	LoriD Try VLOOKUP http://www.mrexcel.com/board/viewtop...5192&forum=2&5 [ This Message was edited by: Brian from Maui on 2002-04-15 11:14 ]

Apr 15th, 2002, 12:13 PM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hiya, Sounds like you could have had a Vlookup.

Apr 15th, 2002, 12:47 PM	#7
LoriD Board Regular Join Date: Apr 2002 Location: Rhode Island Posts: 128	Thanks all, but I think I'll try using VLookup.