Search and retrieve

[dziw]

how can i search a seperate workbook for a certain value, and copy row
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

 

[Niek Otten]

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

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

--
Kind regards,

Niek Otten



|
| 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?action=getinfo&userid=10422
| View this thread: http://www.excelforum.com/showthread.php?threadid=536134
|

 

[dziw]

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]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten

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

 

[dziw]

Thanks All!

This Newbie Got It!