| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically fill in blank cells??
Can I type info in 1 cell and have it automatically put different info in the
next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
Where would the "different info" come from?
"AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
I enter in a lot of item numbers and the same description over and over. So
is it possible to type in the item number in one cell and have it automatically fill in the description in the next cell? "JBoulton" wrote: Where would the "different info" come from? "AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
If you have a table listing the item number and description you could use
=VLOOKUP(). If your table was in D1:E500 and your item number was in A1 you could put the following in B1 and it would return the description: =VLOOKUP(A1,$D$1:$E$500,1,FALSE) Then you could copy B1 down for as many items as you have listed in column A. "AlaskaMX" wrote: I enter in a lot of item numbers and the same description over and over. So is it possible to type in the item number in one cell and have it automatically fill in the description in the next cell? "JBoulton" wrote: Where would the "different info" come from? "AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
Make that =VLOOKUP(A1,$D$1:$E$500,2,FALSE)
Gord Dibben MS Excel MVP On Mon, 4 Sep 2006 12:41:01 -0700, JBoulton wrote: If you have a table listing the item number and description you could use =VLOOKUP(). If your table was in D1:E500 and your item number was in A1 you could put the following in B1 and it would return the description: =VLOOKUP(A1,$D$1:$E$500,1,FALSE) Then you could copy B1 down for as many items as you have listed in column A. "AlaskaMX" wrote: I enter in a lot of item numbers and the same description over and over. So is it possible to type in the item number in one cell and have it automatically fill in the description in the next cell? "JBoulton" wrote: Where would the "different info" come from? "AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
Exactly! Thanks for the correction
"Gord Dibben" wrote: Make that =VLOOKUP(A1,$D$1:$E$500,2,FALSE) Gord Dibben MS Excel MVP On Mon, 4 Sep 2006 12:41:01 -0700, JBoulton wrote: If you have a table listing the item number and description you could use =VLOOKUP(). If your table was in D1:E500 and your item number was in A1 you could put the following in B1 and it would return the description: =VLOOKUP(A1,$D$1:$E$500,1,FALSE) Then you could copy B1 down for as many items as you have listed in column A. "AlaskaMX" wrote: I enter in a lot of item numbers and the same description over and over. So is it possible to type in the item number in one cell and have it automatically fill in the description in the next cell? "JBoulton" wrote: Where would the "different info" come from? "AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically fill in blank cells??
Just the usual "typo patrol" find.
We ALL do it...........the typos, I mean. Gord On Tue, 5 Sep 2006 07:09:14 -0700, JBoulton wrote: Exactly! Thanks for the correction "Gord Dibben" wrote: Make that =VLOOKUP(A1,$D$1:$E$500,2,FALSE) Gord Dibben MS Excel MVP On Mon, 4 Sep 2006 12:41:01 -0700, JBoulton wrote: If you have a table listing the item number and description you could use =VLOOKUP(). If your table was in D1:E500 and your item number was in A1 you could put the following in B1 and it would return the description: =VLOOKUP(A1,$D$1:$E$500,1,FALSE) Then you could copy B1 down for as many items as you have listed in column A. "AlaskaMX" wrote: I enter in a lot of item numbers and the same description over and over. So is it possible to type in the item number in one cell and have it automatically fill in the description in the next cell? "JBoulton" wrote: Where would the "different info" come from? "AlaskaMX" wrote: Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be extremely helpfull in my spreadsheets. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count blank cells that contain formula? | Excel Discussion (Misc queries) | |||
| macro to fill blank cells | Links and Linking in Excel | |||
| Generating truly blank cells | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
