software

I added the example2.xls
He www.geocities.com/saftneger2/Example.zip

I'm trying to lookup Values of Column A in Query1 (SN's) and match them
with Values in Column A of Build list and return Column B of Build list.
(The build date)

However Excel 2000 seems to be unable to identify Query1!A4:A26
When I used the formular editor for vlookup on those values,result:
lookup_values = 42445

It should be:
lookup_values = quot;42445quot;
in order to work.

I copied some SNs from Build list to Query (displayed in Query!A2:A3)
and in this case lookup_value = quot;...quot; and it works.

Why is Excel not able to identify Query1!A4:A26? --
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=532349Hi,

I don't know the why, but I had the same problem with numbers stored as
text. My solution was force all the numbers as numbers (multiply by 1 in a
separate column and copy/paste values) in both the list and the lookup range.

Hope this helps,
Miguel.

quot;Dark_Templarquot; wrote:

gt;
gt; I added the example2.xls
gt; He www.geocities.com/saftneger2/Example.zip
gt;
gt; I'm trying to lookup Values of Column A in Query1 (SN's) and match them
gt; with Values in Column A of Build list and return Column B of Build list.
gt; (The build date)
gt;
gt; However Excel 2000 seems to be unable to identify Query1!A4:A26
gt; When I used the formular editor for vlookup on those values,result:
gt; lookup_values = 42445
gt;
gt; It should be:
gt; lookup_values = quot;42445quot;
gt; in order to work.
gt;
gt; I copied some SNs from Build list to Query (displayed in Query!A2:A3)
gt; and in this case lookup_value = quot;...quot; and it works.
gt;
gt; Why is Excel not able to identify Query1!A4:A26?
gt;
gt;
gt; --
gt; Dark_Templar
gt; ------------------------------------------------------------------------
gt; Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
gt; View this thread: www.excelforum.com/showthread...hreadid=532349
gt;
gt;


U¿ytkownik quot;Dark_Templarquot;
gt; napisa³ w
wiadomoœci newsark_Templar.265uha_1144860601.0285@excelforu m-nospam.com...
gt;
gt; I added the example2.xls
gt; He www.geocities.com/saftneger2/Example.zip
gt;
gt; I'm trying to lookup Values of Column A in Query1 (SN's) and match them
gt; with Values in Column A of Build list and return Column B of Build list.
gt; (The build date)
gt;
gt; However Excel 2000 seems to be unable to identify Query1!A4:A26
gt; When I used the formular editor for vlookup on those values,result:
gt; lookup_values = 42445
gt;
gt; It should be:
gt; lookup_values = quot;42445quot;
gt; in order to work.
gt;
gt; I copied some SNs from Build list to Query (displayed in Query!A2:A3)
gt; and in this case lookup_value = quot;...quot; and it works.
gt;
gt; Why is Excel not able to identify Query1!A4:A26?
gt;
gt;
gt; --
gt; Dark_Templar
gt; ------------------------------------------------------------------------
gt; Dark_Templar's Profile:
www.excelforum.com/member.php...oamp;userid=33279
gt; View this thread: www.excelforum.com/showthread...hreadid=532349
gt;

col A in build list contains text ane vlookup search for number
the eassiest way to convert text to numbers is to select col A choose
data-text to column-finish
mcg

Thank you guys - it's working.

I went to Date,Text to Colums and selected text.--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=532349