Strange vlookup problem

Giganews Newsgroups
Subject: Strange vlookup problem
Posted by:  thiver (thiver.28mvkm_1149014401.4226@excelforum-nospam.com)
Date: Tue, 30 May 2006

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?action=getinfo&userid=34951
View this thread:http://www.excelforum.com/showthread.php?threadid=546815

Replies