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
|