Użytkownik "Dark_Templar"
napisał w
wiadomości news:Dark_Templar.265uha_1144860601.0285@excelforu m-nospam.com...
I added the example2.xls
He 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