Finding A Desciption In Another Book

[drewd]

I have been trying to figure out a way to speed up the way I progam
project.
Every day I have to program a circuit borad to run on a machine.
The set up is
EXAMPLE:
BOOK1
COLUMN A COLUMN B COLUMN C
COLUMN D

C1 DESCRIPTION X-DATA
Y-DATA
C2 DESCRIPTION X-DATA
Y-DATA
C3 DESCRIPTION X-DATA
Y-DATA
C4 DESCRIPTION X-DATA
Y-DATA
R3 DESCRIPTION X-DATA
Y-DATA
R45 DESCRIPTION X-DATA
Y-DATA
R56 DESCRIPTION X-DATA
Y-DATA
ect,ect,ect DESCRIPTION X-DATA
Y-DATA

in a seperate book I have a description list that looks something lik
this
Example:
BOOK2
COLUMN A COLUMN B
C1,C2,C4,C10 0.1UF_10V_0805
R45,R49,R16,R1 10K_1%_0805
ECT,ECT,ECT ECT,ECT,ECT

I need a macro that can look on the two open workbooks and find th
referance data in column a in book1 and then find it in book2 and the
enter the correct description in column b in book1. Keeping in min
that I do up to 10000 programs a week and all are different. They al
have the same setup.

Thank you in advance.
Dre

 

[Bob Phillips]

Not quite sure of your data but something like

=VLOOKUP(A2,[Book1.xls]Sheet1!$A$2:$D$100,2,FALSE)

If you want some flexibility in workbooks, you could store the wrokbook name
in a calle and use say

=VLOOKUP(A2,INDIRECT("'["&H1&"]Sheet2'!$A$2:$D$100"),2,FALSE)
with the workbook name in H1