Hello,

I have vlookup problem which I cant solve. Any help would be
appreciated.

I have two separate sheets. In one I have 2000 cells with coresponding
descriptions and in another some 300 with descriptions. ( So 2000*2 and
300*2 cells). I want to find corespodnig descriptions for items that are
included in both sheets. ( My estimate is, that is around 200 items. )

I have set up vlookup funkcion and it only works for 20 descriptions of
300. Its strange, since I have checked and I have cells marked as text
so this is not the problem.

Why does formula work fore some cells and not for another ? And yes. I
have cells in ascending order.

Cheers


--
thiver
------------------------------------------------------------------------
thiver's Profile: http://www.excelforum.com/member.php...o&userid=34951
View this thread: http://www.excelforum.com/showthread...hreadid=546815