Take a look at

http://www.contextures.com/xlfunctions02.html

If this post helps click Yes
---------------
Jacob Skaria


"Gmata" wrote:

How can i match information from Sheet 1 to SHeet 2 using MODEL NUmber if i
have Model Number in Both sheets.

Thanks