Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem | Excel Discussion (Misc queries) | |||
vlookup problem | Excel Discussion (Misc queries) | |||
vlookup Problem | Excel Discussion (Misc queries) | |||
Strange Excel problem | Setting up and Configuration of Excel | |||
Vlookup Problem | Excel Worksheet Functions |