ChrisHockley
New Member
- Joined
- Feb 6, 2017
- Messages
- 30
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.
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.