Sorting out a column

Jonboy · Apr 17th, 2002, 10:26 AM

Again this is probably trivial but i need help!
Ive got 100 different model names in Column A. Ive also got 75 model names in Column B(which feature in Column A also)with some information about the product in Column C. How do i go about "matching" the lines of data, i.e. the models and data in Columns B & C to the models in Column A?
Think ive explained it?

Mark W. · Apr 17th, 2002, 10:28 AM

See the Excel Help Index topic for the MATCH worksheet function.

Jonboy · Apr 18th, 2002, 04:24 AM

Thanks alot!!

nisht · Apr 18th, 2002, 04:41 AM

Download the file...no 24 from

http://www.pexcel.com/download.htm

here i have given the example of match-index and offset-match , lookups...

hope it can help you

nishith desai
http://www.pexcel.com

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

Apr 17th, 2002, 10:26 AM	#1
Jonboy New Member Join Date: Apr 2002 Posts: 4	Again this is probably trivial but i need help! Ive got 100 different model names in Column A. Ive also got 75 model names in Column B(which feature in Column A also)with some information about the product in Column C. How do i go about "matching" the lines of data, i.e. the models and data in Columns B & C to the models in Column A? Think ive explained it?

Apr 17th, 2002, 10:28 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help Index topic for the MATCH worksheet function.

Apr 18th, 2002, 04:24 AM	#3
Jonboy New Member Join Date: Apr 2002 Posts: 4	Thanks alot!!

Apr 18th, 2002, 04:41 AM	#4
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Download the file...no 24 from http://www.pexcel.com/download.htm here i have given the example of match-index and offset-match , lookups... hope it can help you nishith desai http://www.pexcel.com