> I would like to know if it's possible to create some sort of macro or
> array or VB script so that when a particular text entry in one cell is
> entered, it automatically enters it's definition in the cell next to it.
> In other words, I have a comany that supplies me one text for it's
> product, and we use another text entry internally, and I need a way to
> have the text entry for the vendor's number to return my number in the
> next cell over, without having to constantlly type it in.
> Anyone out there know how to do this? Thanks,
> Heather Minnich
You don't need a macro, you can accomplish what you want with a
worksheet function. You can use VLOOKUP (or HLOOKUP) to do this. Create
a table that lists the whole table of company's text in column X (for
example) & your text in column Y. Let's say the table occupies the range
$X$1:$Y$250. Then let's say you enter company text in a cell A1, you want
your text in B1. Use the following formula in B1:
The syntax of the VLOOKUP function is
See the On-line Help for more info.
E-mail me if you have any problems or questions.
Department of Chemistry, Boston College
Chestnut Hill MA 02167-3860 U. S. A.