Search and retrieve
 

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: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=536134

Search and retrieve
 

Look at the VLOOKUP() function. A good tutorial can be found he

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten



"dziw" 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: http://www.excelforum.com/member.php...o&userid=10422
| View this thread: http://www.excelforum.com/showthread...hreadid=536134
|

Search and retrieve
 

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

i'm not sure how i would formate the "table_array" to do that


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=536134

Search and retrieve
 

is it like "[s:/temp/example.xls]worksheetname!$a$2"


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=536134

Search and retrieve
 

Start the Function Wizard (InsertFunction) and click/select the table by tabbing to it

--
Kind regards,

Niek Otten

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

Search and retrieve
 

Thanks All!

This Newbie Got It!


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=536134