data entry using functions??????

[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

 

[Ian]

I think this is what you mean. You have a table of data in A115. You
enter data in H1 and if it matches eg A5, then J1=B5, K1=C5 and L1=D5. If
that's correct, then you need to use VLOOKUP.

In J1 type
=IF(ISERROR(VLOOKUP($H1,$A$1:$D$15,2,FALSE)),"",(VLOOKUP($H1,$A$1:$D$15,2,FALSE)))
In K1 type the same except change each instance of 2 to 3 and repeat in L1
except with 4.

You can get away with =VLOOKUP($H1,$A$1:$D$15,2,FALSE) but if a cell in
column H is either empty or doesn't match a cell in column A, then you will
get #N/A displayed in columns J to L.

Copy them down the columns.

Column A needs to be in ascending alphanumeric order.

 

[mark]

Thanks, I will give it a try, I looked at Vlookup yesterday but did not
discern how to format it.
Mark