C
cbrah
I have a range named "JDE"(A2
40) that houses a column of PO#s (B2:B40), a
column of Model #s (C2:C40), and a column of Serial #s (D240). I have
another worksheet with a range named "Bren" (E2:H50), that houses a column of
PO#s (E2:E50) and a column for the serial number if the model # on JDE
matches a given model # for that column (ie: column F, holds only serial
numbers for model SAS1000, column G holds only serial numbers for model
FRE2121. How can I write a statement that looks up the corresponding PO# in
JDE, then enters the serial number only if the model number of the JDE row is
"SAS1000" ?
40) that houses a column of PO#s (B2:B40), acolumn of Model #s (C2:C40), and a column of Serial #s (D2
40). I haveanother worksheet with a range named "Bren" (E2:H50), that houses a column of
PO#s (E2:E50) and a column for the serial number if the model # on JDE
matches a given model # for that column (ie: column F, holds only serial
numbers for model SAS1000, column G holds only serial numbers for model
FRE2121. How can I write a statement that looks up the corresponding PO# in
JDE, then enters the serial number only if the model number of the JDE row is
"SAS1000" ?