Function for this?

[ChrisHockley]

I have a very large spread sheet that I am adding new data into. In this are product details. There are dozens of product colors and I'm having to look up each then find the color code assigned to it and add this to the new data.

Essentially

- Column G has the Color Specs with duplicates over 14,000 lines.
- Column BV has the color code that corresponds with the color in Column G
- I'm adding products with the color specs into G and I'd like to have column BV auto populate

I'm thinking V lookup but can't seem to get it to work.

Thoughts?

Thanks so much.

 

[ChrisHockley]

Right now I am just sorting by Column G and copying and pasting the codes from column BV in the empty ones.

 

[Radoslaw Poprawski]

1. on ur table do CTRL+T to convert to proper Table.
2. CTRL+ALT+F1 - on new sheet create a table with unique values from G and corresponding color from BV.
3. use the vlookup on the whole BV column. it'll auto populate whole column if ur Table is set properly.

 

[ChrisHockley]

1. on ur table do CTRL+T to convert to proper Table.
2. CTRL+ALT+F1 - on new sheet create a table with unique values from G and corresponding color from BV.
3. use the vlookup on the whole BV column. it'll auto populate whole column if ur Table is set properly.

This worked great! Thank you for the suggestion.

 

[Radoslaw Poprawski]

you are very welcome glad it helped