Copy text to rows with the same reference number

[scoobydoobie]

Hey guys
first time here,
Im looking for a formula that would do the following:
If there is a specific number in a cell, and next to it in a different cell a text,
then I want for all rows with this number to have the same text in all of them.
is this kind of function exists?
Thank you in advance.

[Richard Buttrey]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

Since this is your first post I'll change it for you but please remembet for the future.

[Sam Capricci]

looks like your title has been changed.
so getting to your problem, let's say your number is in A1 and the text is in B1 and your numbers go down column A and from B2 down it is blank.
this will populate what is in B1 everywhere that it finds a value in column A that matches A1.
=IFERROR(VLOOKUP(A2,$A$1:$B$1,2,FALSE),"")
just drag down or double click on the bottom right of the cell you put it in to autofill down.
it will stop when it encounters a cell in column B that has a value in it.