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.

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.

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.

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.

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.

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.

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.