Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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
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 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   Report Post  
Ian
 
Posts: n/a
Default

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
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 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   Report Post  
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel as Data Entry into Access Database Btibert Excel Discussion (Misc queries) 3 August 29th 05 02:17 PM
can i restrict data entry from certain columns surgeandoj Excel Discussion (Misc queries) 1 July 8th 05 05:28 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Data Validation / Cell Entry 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.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"