Sorting out a column

[Jonboy]

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.]

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

 

[Jonboy]

Thanks alot!!

 

[nisht]

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

ni****h desai
http://www.pexcel.com