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.

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

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

--
Kind regards,

Niek Otten



"dziw" <dziw.26u6en_1145995804.0701@excelforum-nospam.com> wrote in message
news:dziw.26u6en_1145995804.0701@excelforum-nospam.com...
|
| 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
|

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

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

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

--
Kind regards,

Niek Otten

"dziw" <dziw.26u7kc_1145997301.889@excelforum-nospam.com> wrote in message
news:dziw.26u7kc_1145997301.889@excelforum-nospam.com...
|
| 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
|

Thanks All!

This Newbie Got It!