Remember Me?

#1
 Posts: n/a
data entry using functions??????

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

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 A1:D1
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

#2
 Ian Posts: n/a

I think this is what you mean. You have a table of data in A1:D15. 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)),"",(V LOOKUP(\$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.
--
Ian
--
wrote in message
ups.com...
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

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 A1:D1
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

#3
 Posts: n/a

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Btibert Excel Discussion (Misc queries) 3 August 29th 05 02:17 PM surgeandoj Excel Discussion (Misc queries) 1 July 8th 05 05:28 PM David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM Steve Jones Excel Discussion (Misc queries) 4 March 23rd 05 04:23 PM

All times are GMT +1. The time now is 09:25 AM.