Cell Automation

[Guest]

Hello,
I was wonder if there is a way of to kind of autofill adjoining cells.
Example: I type in a item in a1, Excel would search a database and put the
discription for that tem in b2. I could use this for a couple of excel
templates.I don't have that much experiance at programming a any help would
be appreciated.

Thanks

 

[Nick Hodge]

Lee

You need the VLOOKUP worksheet function. Try looking this up in help and
post back if you get stuck

The general syntax is....(Very Pseudo!)

=VLOOKUP(Value_To_Look_Up,Database_To_Look_In,
Rows_Offset,Find_Exact_Match_Or_Not)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)