Autofill values if they match in another column

[entranced]

Hello everyone!

I'm a newbie here, so please don't hate me if I'm asking a stupid question!

I'm having the table below.

Now, when I start filling data in column B, I want all the rows in column B to get the same value if they match in column A.
For example, if I write "Ana" in B1, I want that value to appear in all the rows that have the same value as A1.
If I write "Laura" in B2, I want to get the value "Laura" also in B3, B5 and B8, because they match in column A (same value - 222)

Any help?

asda.png

[jeffreybrown]

Hello entranced & Welcome to the Forum,

I would suggest you build a lookup table and then use a vlookup function to return the correct value.

http://www.contextures.com/xlFunctions02.html

[Pete_UK]

Put this formula in B2:

=IFERROR(VLOOKUP(A2,A$1:B1,2,0)&"","")

then copy down.

Then you can add your names to B1, B2 etc. (over-writing the formula in B2).

Hope this helps.

Pete