Autofill from column B to C

[justjon87]

Hi guys,

I'm after a formula or script which will look at what the user is entering (which will be a number), and then autofill the field next to it based on that number... I want it to grab the number/names from a text or database file of some sort, then match them up from there.

Is this possible?

[Domski]

Almost certainly. Some more details would be required for a more specific answer as to how.

Dom

[justjon87]

Great,

Column B is a number compromising of between 1 and 4 digits.
Column C is a name that refers / is connected to those digits (so 200 = mr wallace, 211= mrs hannaghan) etc etc

I would like it so if 200 was typed, it would autofill the C box wil mr wallace, 211 mrs hannaghan.

The list would need to be contained in some sort of host file or even another tab within the spreadsheet, whatevers easiest... but the list would compromise of over 2000 numbers.

Thanks in advance for any help

[Domski]

Attached is a formula approach.

Dom

[justjon87]

Hi Dom,

Thank you so much, this worked perfectly!

Can I be akward and ask one more thing?

Is it possible rather than it routing to a worksheet, to get it to look at an excel file in a certain directory instead, or not?

[Domski]

Sure, the lookup table can sit within another workbook if required.

Dom

[justjon87]

Great, is it a simple matter of entering the directory inplace of worksheet name?

[Domski]

Easiest way is to have both files open and just create the formula referencing the other workbook.

Dom

[justjon87]

That simple!

Thanks for all your help, appreciated.