M
mark
I would like to type in one cell data and have data returned to another
cell.
Example:
A1 B1 C1 D1...........H1...J1 K1 L1
data typed into H1 matches data in A1; I need data in B1 C1 D1 to
return to J1 K1 L1.
I would like to copy the formulas down in J1:L1 thru 30 or so rows but
may have
only 15 rows of data in A11
Data entered in the H1:31 should match one of the entries in A1:15 and
return the corresponding data in B,C,D 1:15 to the corresponding cells
in J,K,L 1:31
I cannot figure out how to do this, the IF function won't do this in
any format I can discern.
Hope I have made myself clear.
Mark
cell.
Example:
A1 B1 C1 D1...........H1...J1 K1 L1
data typed into H1 matches data in A1; I need data in B1 C1 D1 to
return to J1 K1 L1.
I would like to copy the formulas down in J1:L1 thru 30 or so rows but
may have
only 15 rows of data in A11
Data entered in the H1:31 should match one of the entries in A1:15 and
return the corresponding data in B,C,D 1:15 to the corresponding cells
in J,K,L 1:31
I cannot figure out how to do this, the IF function won't do this in
any format I can discern.
Hope I have made myself clear.
Mark