software

Hi, first post ever ever! Can you help?When using worksheet quot;Aquot; I want an equation to look at one cell
reference in worksheet quot;Bquot; searching for same reference and pull
information through. Worksheet quot;Bquot; may not be open when lookup needs to
operate.--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=501503Open workbook B.
Goto workbook A.
In your cell, type = then Ctrl-F6 to get to workbook, select the cell, then
Enter.

Workbook A will update the path when workbook B is closed.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Boethius1quot; gt; wrote
in message ...
gt;
gt; Hi, first post ever ever! Can you help?
gt;
gt;
gt; When using worksheet quot;Aquot; I want an equation to look at one cell
gt; reference in worksheet quot;Bquot; searching for same reference and pull
gt; information through. Worksheet quot;Bquot; may not be open when lookup needs to
gt; operate.
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile:
www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=501503
gt;

Bob Phillips Wrote:
gt; Open workbook B.
gt; Goto workbook A.
gt; In your cell, type = then Ctrl-F6 to get to workbook, select the cell,
gt; then
gt; Enter.
gt;
gt; Workbook A will update the path when workbook B is closed.
gt;
gt; ...................
gt;
gt; Wow that was a quick reply, thanks it works great BUT!
gt;
gt; with that method I am still doing the search, I want an automatic
gt; method. I have typed the following equation but it is not working, any
gt; ideas why path is wrong?
gt;
gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;
gt; With this equation I am trying to look up number from C4 within the
gt; range of C4 to H41 from the file shown in path so that it will pull
gt; through the text from column 3.--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=501503The syntax is incorrect - your paran is in the wrong place and you're missing
a comma:

You have
=VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)

You should have
=VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code
Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)

BTW, you may want to add the final range argument to be quot;falsequot; to avoid the
lookup bringing in the quot;closest matchquot; to the requested data.
=VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)

Hope this helps.
--
ERR229quot;Boethius1quot; wrote:

gt;
gt; Bob Phillips Wrote:
gt; gt; Open workbook B.
gt; gt; Goto workbook A.
gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select the cell,
gt; gt; then
gt; gt; Enter.
gt; gt;
gt; gt; Workbook A will update the path when workbook B is closed.
gt; gt;
gt; gt; ...................
gt; gt;
gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt; gt;
gt; gt; with that method I am still doing the search, I want an automatic
gt; gt; method. I have typed the following equation but it is not working, any
gt; gt; ideas why path is wrong?
gt; gt;
gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;
gt; gt; With this equation I am trying to look up number from C4 within the
gt; gt; range of C4 to H41 from the file shown in path so that it will pull
gt; gt; through the text from column 3.
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=501503
gt;
gt;


Hi, thanks for your reply. However still can't get to work.

Have simplified path to

=VLOOKUP(C10,'C:\New Code Set
up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)

When ask it to look it does not pull through info and deletes the C:
drive and folder path from equation to leave

=VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)

Very confusing!

Thanks for the BTW but first things first!

Thanks, Sharon

----------------------ERR229 Wrote:
gt; The syntax is incorrect - your paran is in the wrong place and you're
gt; missing
gt; a comma:
gt;
gt; You have
gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;
gt; You should have
gt; =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code
gt; Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)
gt;
gt; BTW, you may want to add the final range argument to be quot;falsequot; to
gt; avoid the
gt; lookup bringing in the quot;closest matchquot; to the requested data.
gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)
gt;
gt; Hope this helps.
gt; --
gt; ERR229
gt;
gt;
gt; quot;Boethius1quot; wrote:
gt;
gt; gt;
gt; gt; Bob Phillips Wrote:
gt; gt; gt; Open workbook B.
gt; gt; gt; Goto workbook A.
gt; gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select the
gt; cell,
gt; gt; gt; then
gt; gt; gt; Enter.
gt; gt; gt;
gt; gt; gt; Workbook A will update the path when workbook B is closed.
gt; gt; gt;
gt; gt; gt; ...................
gt; gt; gt;
gt; gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt; gt; gt;
gt; gt; gt; with that method I am still doing the search, I want an automatic
gt; gt; gt; method. I have typed the following equation but it is not working,
gt; any
gt; gt; gt; ideas why path is wrong?
gt; gt; gt;
gt; gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; Code
gt; gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt; gt;
gt; gt; gt; With this equation I am trying to look up number from C4 within
gt; the
gt; gt; gt; range of C4 to H41 from the file shown in path so that it will
gt; pull
gt; gt; gt; through the text from column 3.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Boethius1
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Boethius1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;
gt; gt;--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=501503That's because the workbook you lookup in is open, if you close it you'll
get the full path

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Boethius1quot; gt; wrote in
message ...
gt;
gt; Hi, thanks for your reply. However still can't get to work.
gt;
gt; Have simplified path to
gt;
gt; =VLOOKUP(C10,'C:\New Code Set
gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;
gt; When ask it to look it does not pull through info and deletes the C:
gt; drive and folder path from equation to leave
gt;
gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;
gt; Very confusing!
gt;
gt; Thanks for the BTW but first things first!
gt;
gt; Thanks, Sharon
gt;
gt; ----------------------
gt;
gt;
gt; ERR229 Wrote:
gt;gt; The syntax is incorrect - your paran is in the wrong place and you're
gt;gt; missing
gt;gt; a comma:
gt;gt;
gt;gt; You have
gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt;
gt;gt; You should have
gt;gt; =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New Code
gt;gt; Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)
gt;gt;
gt;gt; BTW, you may want to add the final range argument to be quot;falsequot; to
gt;gt; avoid the
gt;gt; lookup bringing in the quot;closest matchquot; to the requested data.
gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New Code
gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)
gt;gt;
gt;gt; Hope this helps.
gt;gt; --
gt;gt; ERR229
gt;gt;
gt;gt;
gt;gt; quot;Boethius1quot; wrote:
gt;gt;
gt;gt; gt;
gt;gt; gt; Bob Phillips Wrote:
gt;gt; gt; gt; Open workbook B.
gt;gt; gt; gt; Goto workbook A.
gt;gt; gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select the
gt;gt; cell,
gt;gt; gt; gt; then
gt;gt; gt; gt; Enter.
gt;gt; gt; gt;
gt;gt; gt; gt; Workbook A will update the path when workbook B is closed.
gt;gt; gt; gt;
gt;gt; gt; gt; ...................
gt;gt; gt; gt;
gt;gt; gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt;gt; gt; gt;
gt;gt; gt; gt; with that method I am still doing the search, I want an automatic
gt;gt; gt; gt; method. I have typed the following equation but it is not working,
gt;gt; any
gt;gt; gt; gt; ideas why path is wrong?
gt;gt; gt; gt;
gt;gt; gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt;gt; Code
gt;gt; gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt; gt; gt;
gt;gt; gt; gt; With this equation I am trying to look up number from C4 within
gt;gt; the
gt;gt; gt; gt; range of C4 to H41 from the file shown in path so that it will
gt;gt; pull
gt;gt; gt; gt; through the text from column 3.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Boethius1
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt; Boethius1's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30497
gt;gt; gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=501503
gt;gt; gt;
gt;gt; gt;
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=501503
gt;
Thanks Peo, that makes sense. However problem remains the equation is
still not pulling through required information.

Any ideas?

Thanks

--------------Peo Sjoblom Wrote:
gt; That's because the workbook you lookup in is open, if you close it
gt; you'll
gt; get the full path
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Boethius1quot; gt;
gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi, thanks for your reply. However still can't get to work.
gt; gt;
gt; gt; Have simplified path to
gt; gt;
gt; gt; =VLOOKUP(C10,'C:\New Code Set
gt; gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;
gt; gt; When ask it to look it does not pull through info and deletes the C:
gt; gt; drive and folder path from equation to leave
gt; gt;
gt; gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;
gt; gt; Very confusing!
gt; gt;
gt; gt; Thanks for the BTW but first things first!
gt; gt;
gt; gt; Thanks, Sharon
gt; gt;
gt; gt; ----------------------
gt; gt;
gt; gt;
gt; gt; ERR229 Wrote:
gt; gt;gt; The syntax is incorrect - your paran is in the wrong place and
gt; you're
gt; gt;gt; missing
gt; gt;gt; a comma:
gt; gt;gt;
gt; gt;gt; You have
gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; Code
gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt;
gt; gt;gt; You should have
gt; gt;gt; =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New
gt; Code
gt; gt;gt; Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)
gt; gt;gt;
gt; gt;gt; BTW, you may want to add the final range argument to be quot;falsequot; to
gt; gt;gt; avoid the
gt; gt;gt; lookup bringing in the quot;closest matchquot; to the requested data.
gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; Code
gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)
gt; gt;gt;
gt; gt;gt; Hope this helps.
gt; gt;gt; --
gt; gt;gt; ERR229
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Boethius1quot; wrote:
gt; gt;gt;
gt; gt;gt; gt;
gt; gt;gt; gt; Bob Phillips Wrote:
gt; gt;gt; gt; gt; Open workbook B.
gt; gt;gt; gt; gt; Goto workbook A.
gt; gt;gt; gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select
gt; the
gt; gt;gt; cell,
gt; gt;gt; gt; gt; then
gt; gt;gt; gt; gt; Enter.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Workbook A will update the path when workbook B is closed.
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; ...................
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; with that method I am still doing the search, I want an
gt; automatic
gt; gt;gt; gt; gt; method. I have typed the following equation but it is not
gt; working,
gt; gt;gt; any
gt; gt;gt; gt; gt; ideas why path is wrong?
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; gt;gt; Code
gt; gt;gt; gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; With this equation I am trying to look up number from C4 within
gt; gt;gt; the
gt; gt;gt; gt; gt; range of C4 to H41 from the file shown in path so that it will
gt; gt;gt; pull
gt; gt;gt; gt; gt; through the text from column 3.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Boethius1
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; ------------------------------------------------------------------------
gt; gt;gt; gt; Boethius1's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt;gt; gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Boethius1
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Boethius1's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=501503Can you do this test, open both workbooks, then use

=C10= go to the other work book and click on the cell that is supposedly a
match, then press enter.

If you get FALSE there might be things like trailing or leading spaces, if
imported from the web there might be invisible line feed like char 160

Also use ,0 after the 3 (column index) like

=VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3,0)

or FALSE like in (0 is the same as FALSE in this case)

=VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3,FALSE)

that way your formula looks for an exact match (I believe this was mentioned
by an earlier poster) and can explain unexpected errors

Post back if you get FALSE with the comparison cell to cell

=C10=[gcodenewsetupcopy.xls]Sheet1'!C4

replace C4 with the cell you are sure is a match in the lookup workbook--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Boethius1quot; gt; wrote
in message ...
gt;
gt; Thanks Peo, that makes sense. However problem remains the equation is
gt; still not pulling through required information.
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt; --------------
gt;
gt;
gt; Peo Sjoblom Wrote:
gt;gt; That's because the workbook you lookup in is open, if you close it
gt;gt; you'll
gt;gt; get the full path
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Boethius1quot; gt;
gt;gt; wrote in
gt;gt; message ...
gt;gt; gt;
gt;gt; gt; Hi, thanks for your reply. However still can't get to work.
gt;gt; gt;
gt;gt; gt; Have simplified path to
gt;gt; gt;
gt;gt; gt; =VLOOKUP(C10,'C:\New Code Set
gt;gt; gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt; gt;
gt;gt; gt; When ask it to look it does not pull through info and deletes the C:
gt;gt; gt; drive and folder path from equation to leave
gt;gt; gt;
gt;gt; gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt; gt;
gt;gt; gt; Very confusing!
gt;gt; gt;
gt;gt; gt; Thanks for the BTW but first things first!
gt;gt; gt;
gt;gt; gt; Thanks, Sharon
gt;gt; gt;
gt;gt; gt; ----------------------
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; ERR229 Wrote:
gt;gt; gt;gt; The syntax is incorrect - your paran is in the wrong place and
gt;gt; you're
gt;gt; gt;gt; missing
gt;gt; gt;gt; a comma:
gt;gt; gt;gt;
gt;gt; gt;gt; You have
gt;gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt;gt; Code
gt;gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt; gt;gt;
gt;gt; gt;gt; You should have
gt;gt; gt;gt; =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New
gt;gt; Code
gt;gt; gt;gt; Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)
gt;gt; gt;gt;
gt;gt; gt;gt; BTW, you may want to add the final range argument to be quot;falsequot; to
gt;gt; gt;gt; avoid the
gt;gt; gt;gt; lookup bringing in the quot;closest matchquot; to the requested data.
gt;gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt;gt; Code
gt;gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)
gt;gt; gt;gt;
gt;gt; gt;gt; Hope this helps.
gt;gt; gt;gt; --
gt;gt; gt;gt; ERR229
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Boethius1quot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Bob Phillips Wrote:
gt;gt; gt;gt; gt; gt; Open workbook B.
gt;gt; gt;gt; gt; gt; Goto workbook A.
gt;gt; gt;gt; gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select
gt;gt; the
gt;gt; gt;gt; cell,
gt;gt; gt;gt; gt; gt; then
gt;gt; gt;gt; gt; gt; Enter.
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Workbook A will update the path when workbook B is closed.
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; ...................
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; with that method I am still doing the search, I want an
gt;gt; automatic
gt;gt; gt;gt; gt; gt; method. I have typed the following equation but it is not
gt;gt; working,
gt;gt; gt;gt; any
gt;gt; gt;gt; gt; gt; ideas why path is wrong?
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt;gt; gt;gt; Code
gt;gt; gt;gt; gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; With this equation I am trying to look up number from C4 within
gt;gt; gt;gt; the
gt;gt; gt;gt; gt; gt; range of C4 to H41 from the file shown in path so that it will
gt;gt; gt;gt; pull
gt;gt; gt;gt; gt; gt; through the text from column 3.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Boethius1
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt;gt; gt; Boethius1's Profile:
gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=30497
gt;gt; gt;gt; gt; View this thread:
gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=501503
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Boethius1
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt; Boethius1's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30497
gt;gt; gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=501503
gt;gt; gt;
gt;
gt;
gt; --
gt; Boethius1
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Boethius1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30497
gt; View this thread: www.excelforum.com/showthread...hreadid=501503
gt;
Hi and thanks, problem is sorted. Think it might have been the quot;FALSEquot;
addition but I have a feeling it was more to do with me walking away
from the problem for a couple of days!! Being self-trained on excel I
am sure it could get it to work a lot harder for me if I knew what I
was doing!
Thanks again, I am working on my next problem.

--------------------
Peo Sjoblom Wrote:
gt; Can you do this test, open both workbooks, then use
gt;
gt; =C10= go to the other work book and click on the cell that is
gt; supposedly a
gt; match, then press enter.
gt;
gt; If you get FALSE there might be things like trailing or leading spaces,
gt; if
gt; imported from the web there might be invisible line feed like char 160
gt;
gt; Also use ,0 after the 3 (column index) like
gt;
gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3,0)
gt;
gt; or FALSE like in (0 is the same as FALSE in this case)
gt;
gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3,FALSE)
gt;
gt; that way your formula looks for an exact match (I believe this was
gt; mentioned
gt; by an earlier poster) and can explain unexpected errors
gt;
gt; Post back if you get FALSE with the comparison cell to cell
gt;
gt; =C10=[gcodenewsetupcopy.xls]Sheet1'!C4
gt;
gt; replace C4 with the cell you are sure is a match in the lookup
gt; workbook
gt;
gt;
gt;
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Boethius1quot; gt;
gt; wrote
gt; in message
gt; ...
gt; gt;
gt; gt; Thanks Peo, that makes sense. However problem remains the equation
gt; is
gt; gt; still not pulling through required information.
gt; gt;
gt; gt; Any ideas?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; --------------
gt; gt;
gt; gt;
gt; gt; Peo Sjoblom Wrote:
gt; gt;gt; That's because the workbook you lookup in is open, if you close it
gt; gt;gt; you'll
gt; gt;gt; get the full path
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Portland, Oregon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Boethius1quot; gt;
gt; gt;gt; wrote in
gt; gt;gt; message
gt; ...
gt; gt;gt; gt;
gt; gt;gt; gt; Hi, thanks for your reply. However still can't get to work.
gt; gt;gt; gt;
gt; gt;gt; gt; Have simplified path to
gt; gt;gt; gt;
gt; gt;gt; gt; =VLOOKUP(C10,'C:\New Code Set
gt; gt;gt; gt; up\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt; gt;
gt; gt;gt; gt; When ask it to look it does not pull through info and deletes the
gt; C:
gt; gt;gt; gt; drive and folder path from equation to leave
gt; gt;gt; gt;
gt; gt;gt; gt; =VLOOKUP(C10,[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt; gt;
gt; gt;gt; gt; Very confusing!
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks for the BTW but first things first!
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks, Sharon
gt; gt;gt; gt;
gt; gt;gt; gt; ----------------------
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; ERR229 Wrote:
gt; gt;gt; gt;gt; The syntax is incorrect - your paran is in the wrong place and
gt; gt;gt; you're
gt; gt;gt; gt;gt; missing
gt; gt;gt; gt;gt; a comma:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; You have
gt; gt;gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; gt;gt; Code
gt; gt;gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; You should have
gt; gt;gt; gt;gt; =VLOOKUP(C10,'C:\Documents and Settings\SharonS\My Documents\New
gt; gt;gt; Code
gt; gt;gt; gt;gt; Setup\gcodenewsetupcopy.xlsSheet1'!C4:H81,3)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; BTW, you may want to add the final range argument to be quot;falsequot;
gt; to
gt; gt;gt; gt;gt; avoid the
gt; gt;gt; gt;gt; lookup bringing in the quot;closest matchquot; to the requested data.
gt; gt;gt; gt;gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My Documents\New
gt; gt;gt; Code
gt; gt;gt; gt;gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3, false)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Hope this helps.
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; ERR229
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Boethius1quot; wrote:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Bob Phillips Wrote:
gt; gt;gt; gt;gt; gt; gt; Open workbook B.
gt; gt;gt; gt;gt; gt; gt; Goto workbook A.
gt; gt;gt; gt;gt; gt; gt; In your cell, type = then Ctrl-F6 to get to workbook, select
gt; gt;gt; the
gt; gt;gt; gt;gt; cell,
gt; gt;gt; gt;gt; gt; gt; then
gt; gt;gt; gt;gt; gt; gt; Enter.
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Workbook A will update the path when workbook B is closed.
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; ...................
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; Wow that was a quick reply, thanks it works great BUT!
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; with that method I am still doing the search, I want an
gt; gt;gt; automatic
gt; gt;gt; gt;gt; gt; gt; method. I have typed the following equation but it is not
gt; gt;gt; working,
gt; gt;gt; gt;gt; any
gt; gt;gt; gt;gt; gt; gt; ideas why path is wrong?
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; =VLOOKUPC10('C:\Documents and Settings\SharonS\My
gt; Documents\New
gt; gt;gt; gt;gt; Code
gt; gt;gt; gt;gt; gt; gt; Setup\[gcodenewsetupcopy.xls]Sheet1'!C4:H81,3)
gt; gt;gt; gt;gt; gt; gt;
gt; gt;gt; gt;gt; gt; gt; With this equation I am trying to look up number from C4
gt; within
gt; gt;gt; gt;gt; the
gt; gt;gt; gt;gt; gt; gt; range of C4 to H41 from the file shown in path so that it
gt; will
gt; gt;gt; gt;gt; pull
gt; gt;gt; gt;gt; gt; gt; through the text from column 3.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt; Boethius1
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; ------------------------------------------------------------------------
gt; gt;gt; gt;gt; gt; Boethius1's Profile:
gt; gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt;gt; gt;gt; gt; View this thread:
gt; gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Boethius1
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; ------------------------------------------------------------------------
gt; gt;gt; gt; Boethius1's Profile:
gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt;gt; gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Boethius1
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Boethius1's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30497
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501503
gt; gt;--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=501503