23 October 2013
1.=vlookup(select 1 sheet item no coloum, than go to the second sheet select the field agaianst which you require vllokup and suppose your require data in coloum B than 2,0) 2.Check wether vlookup formula fixed or not means selected sheet should be fixed otherwise Put $ sign or f4 for Fixed that
Do that I think your problem will solve otherwise mail me ur sheet I will Show you(bipinc.a2006@gmail.com)