This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have one column (Col 2) with data (list of electrical cable configurations). I have a second (Col 1) that has categorized each configuration. I would like to extrapolate this Col 1 all the way down to match each configuration with a category. I think some type of Vlookup should be used but I'm not sure what formula to use.
Ex:
Col 1 Col 2
Red 15 in 3 p
Yellow 7 in 7 p
Red 15 in 3 p
Green 14 in 1 p
Blue 3 in 6 p
Yellow 7 in 7 p
14 in 1 p
3 in 6 p
7 in 7 p
15 in 3 p
14 in 1 p
3 in 6 p
So, I have already added the Col 1 data for some rows but I want the remaining rows to be able to be filled in by matching the Col 2 data. This looks simple in the example but there are ~1000 rows so I don't want to do it by hand. THANKS!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi,
Assuming that the colours you entered are all the different ones and assuming that red start in cell A2 and the last Yellow is in A6 you can use in A7
=index($A$2:$A$6,match(B7,$B$2:$B$6,0))
copy formula down