Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default FILL IN DATA USING KEY VALUE

CAN I TYPE A NUMBER IN A CELL THEN HAVE EXCEL SEARCH ANOTHER WORKSHEET FOR
THAT NUMBER THEN FILL IN THE DATA FROM THAT LINE INTO
MY NEW LINE. PROBABLY NOT..
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default FILL IN DATA USING KEY VALUE

Most assuredly.......yes

Check out VLOOKUP in help

Basics are you need an input cell with a value to lookup and table to look
in and a series of VLOOKUP formulas to pull the info.

Sheet1 A1 is your input cell.

Sheet2 $A$1:$F$100 is your table with values to lookup in column A

In Sheet1 B1 =VLOOKUP($A1,Sheet2!$A$1:$F$100,2,FALSE)

Copy across to F1 and edit the 2 to 3 to 4 etc.

To copy across without editing use this in B1

=VLOOKUP($A1,Sheet2!$A$1:$F$100,COLUMN(),FALSE)

Enter a value in Sheet1 A1


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 16:26:00 -0700, oregon62
wrote:

CAN I TYPE A NUMBER IN A CELL THEN HAVE EXCEL SEARCH ANOTHER WORKSHEET FOR
THAT NUMBER THEN FILL IN THE DATA FROM THAT LINE INTO
MY NEW LINE. PROBABLY NOT..


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
Data Fill SAL Excel Discussion (Misc queries) 4 September 5th 07 05:59 PM
Filter data and fill only filtered data Thad Meyers[_2_] Excel Discussion (Misc queries) 1 August 30th 07 06:26 PM
fill data manjunath Excel Discussion (Misc queries) 1 March 31st 07 02:26 AM
Fill in data if PaolaAndrea Excel Discussion (Misc queries) 5 February 27th 06 08:51 PM
I have a list of data, fill in the gaps. FILL function won't work Triv Excel Discussion (Misc queries) 1 September 17th 05 02:33 PM


All times are GMT +1. The time now is 02:35 PM.

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

About Us

"It's about Microsoft Excel"