Hello all (newbie):

I need to: read the content of a cell input, compare its value with a list
of data and populate the contiguous cell with the corresponding value, like
an autocomplete function.

wich one is the easiest method?
i thought of
writing the data on another sheet, compare the value on a worksheet
event
same, but using an array
same, but with some sort of database-list
create one line txt files, import the text of the file named like the
cell input (managed to work this one, but seems clumsy)

all of them pose dificulties to me (new to this) so someone could please
tell me which one is easier-smarter and give me some guidelines, links or
code to get started.

the number of entries would be small-medium, not more than a hundred

I have an existing worksheet change event that does this with an image,
i.e., it reads a number from a cell and retrieves a jpg archive named with
that number. So another possible solution would be to read the caption
embedded within a jpg archive, but at first glance this seems complicated.

thanks in advance to all