automatically fill in blank cells??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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.
 
Make that =VLOOKUP(A1,$D$1:$E$500,2,FALSE)


Gord Dibben MS Excel MVP
 
Just the usual "typo patrol" find.

We ALL do it...........the typos, I mean.


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically fill cells when selecting from a drop down list 3
Excel VBA 1
Data Validation-pick from dropdown and next cell auto fills in inf 1
I can't autofill cells in a column if blank cells in between 1
autofill down won't work!!!! 3
Create a custom fill series or sorting order 1
Adding fill to cells only when value is "No" in another cell 1
If blank cell, copy information from cell above 5

Back
Top