Copying corresponding values

**freaksareus** · 04-21-2009, 08:20 AM

I need some help.
I have these values in one column
706
706
706
512
512
12
12
12
12

In an another column I have same values and in the next column some more values that correspond to the previous values
12 red
512 blue
706 orange

I need a formula that can automatically copy those text values according to number values.
706 orange
706 orange
706 orange
512 blue
512 blue
12 red
12 red
12 red
12 red

I have tried =lookup and some variations of =if, but no good result so far.
I appreciate the help.

**NBVC** · 04-21-2009, 08:23 AM

Did you try Vlookup()?

e.g. =Vlookup(A1,$B$1:$C$5,2,FALSE) copied down

where A1 is the first 706 to look up and B1:C5 contains your lookup table.

**Shijesh Kumar** · 04-21-2009, 08:26 AM

Can you post your work sheet .. coz vlookup shuld work..( i dont use excell 2007)

**freaksareus** · 04-21-2009, 09:03 AM

Thaks very much.
vlookup worked well. Just didn't know how to properly use it

**NBVC** · 04-21-2009, 09:06 AM

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save