VLOOKUP being messed up by formating? Help..

[Dark_Templar]

I added the example2.xls
Here: http://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 = "42445"
in order to work.

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

Why is Excel not able to identify Query1!A4:A26?

[Gazeta]

Użytkownik "Dark_Templar"
<[email protected]> napisał w
wiadomości news:[email protected]...
>
> I added the example2.xls
> Here: http://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 = "42445"
> in order to work.
>
> I copied some SNs from Build list to Query (displayed in Query!A2:A3)
> and in this case lookup_value = "..." and it works.
>
> Why is Excel not able to identify Query1!A4:A26?
>
>
> --
> Dark_Templar
> ------------------------------------------------------------------------
> Dark_Templar's Profile:
http://www.excelforum.com/member.php...o&userid=33279
> View this thread: http://www.excelforum.com/showthread...hreadid=532349
>

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

[Miguel Zapico]

Hi,

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.

"Dark_Templar" wrote:

>
> I added the example2.xls
> Here: http://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 = "42445"
> in order to work.
>
> I copied some SNs from Build list to Query (displayed in Query!A2:A3)
> and in this case lookup_value = "..." and it works.
>
> Why is Excel not able to identify Query1!A4:A26?
>
>
> --
> Dark_Templar
> ------------------------------------------------------------------------
> Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
> View this thread: http://www.excelforum.com/showthread...hreadid=532349
>
>

[Dark_Templar]

Thank you guys - it's working.

I went to Date,Text to Colums and selected text.