Strange vlookup problem
 

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

Strange vlookup problem
 

Have you checked that the range that you are looking in is addressed
absolutely (i.e. with $ signs). I've seen cases where relative
addresses have been used and misteriously VLOOKUP appears to shop
working once you get away from the top of the sheet.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=546815

Strange vlookup problem
 

mrice Wrote:
Have you checked that the range that you are looking in is addressed
absolutely (i.e. with $ signs). I've seen cases where relative
addresses have been used and misteriously VLOOKUP appears to shop
working once you get away from the top of the sheet.

Hey,

Thank you for your help.

I checked and yes, ... I have $ signs so my problem is still here.

Cheers


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

Strange vlookup problem
 

Check for extraneous blanks or non-printable characters.

"thiver" wrote:


mrice Wrote:
Have you checked that the range that you are looking in is addressed
absolutely (i.e. with $ signs). I've seen cases where relative
addresses have been used and misteriously VLOOKUP appears to shop
working once you get away from the top of the sheet.

Hey,

Thank you for your help.

I checked and yes, ... I have $ signs so my problem is still here.

Cheers


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

Strange vlookup problem
 

Just because a cell is formatted as text doesn't mean that its value is text.

If you have a couple of extra cells, you can use these kinds of formulas to
verify your data:

=count(a1:a10)
to count the numbers in a1:a10

=counta(a1:a10)
to count anything (formulas/values/text/numbers) in a1:a10

=isnumber(a1)
returns true if a1 is a number

=istext(a1)
returns true if a1 is text (not empty and not a number)



thiver wrote:

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

--

Dave Peterson