software

how can i search a seperate workbook for a certain value, and copy rows
related to that value,
hear is the situation

JOB client description
06-001 awg designs house design

i want to search for that job number

and return the client and description back to the other workbook

sorry if it seams confusing.

thanks yo.--
dziw
------------------------------------------------------------------------
dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
View this thread: www.excelforum.com/showthread...hreadid=536134Look at the VLOOKUP() function. A good tutorial can be found he

www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
quot;dziwquot; gt; wrote in message
...
|
| how can i search a seperate workbook for a certain value, and copy rows
| related to that value,
| hear is the situation
|
| JOB client description
| 06-001 awg designs house design
|
| i want to search for that job number
|
| and return the client and description back to the other workbook
|
| sorry if it seams confusing.
|
| thanks yo.
|
|
| --
| dziw
| ------------------------------------------------------------------------
| dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
| View this thread: www.excelforum.com/showthread...hreadid=536134
|

can the Vlookup be used to seach a seperate workbook on a diffrent disk
drive?

i'm not sure how i would formate the quot;table_arrayquot; to do that--
dziw
------------------------------------------------------------------------
dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
View this thread: www.excelforum.com/showthread...hreadid=536134
is it like quot;[s:/temp/example.xls]worksheetname!$a$2quot;--
dziw
------------------------------------------------------------------------
dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
View this thread: www.excelforum.com/showthread...hreadid=536134Start the Function Wizard (Insertgt;Function) and click/select the table by tabbing to it

--
Kind regards,

Niek Otten

quot;dziwquot; gt; wrote in message
...
|
| is it like quot;[s:/temp/example.xls]worksheetname!$a$2quot;
|
|
| --
| dziw
| ------------------------------------------------------------------------
| dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
| View this thread: www.excelforum.com/showthread...hreadid=536134
|

Thanks All!

This Newbie Got It!--
dziw
------------------------------------------------------------------------
dziw's Profile: www.excelforum.com/member.php...oamp;userid=10422
View this thread: www.excelforum.com/showthread...hreadid=536134