See the Excel Help Index topic for the MATCH worksheet function.
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?
See the Excel Help Index topic for the MATCH worksheet function.
Thanks alot!!
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
Like this thread? Share it with others