Populate a cell based on adjacent cell

[sara.hood]

I have a worksheet that contains outgoing call data. The first column
is the Group Number column, so each record begins with this group
number.

I've inserted a column to the left of the Group Number column. I want
to populate it with a textual Group Name based on that the number in
the adjacent cell.

For example, currently I have:

Group 1 | some data | some data | some data |
Group 1 | some data | some data | some data |
Group 1 | some data | some data | some data |
Group 2 | some data | some data | some data |
Group 2 | some data | some data | some data |

What I want is this:

Group Name A | Group 1 | some data | some data | some data |
Group Name A | Group 1 | some data | some data | some data |
Group Name A | Group 1 | some data | some data | some data |
Group Name B | Group 2 | some data | some data | some data |
Group Name B | Group 2 | some data | some data | some data |

This worksheet has 14,000 rows. Is there an easy way to populate all
those rows without having to copy and paste so much? A macro, a
function?

Thank you.

 

[Sara]

Nevermind, I figured it out!

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