Hello all, looking for a little help with an excel function. I'm not even 100% sure WHICH function I should be trying to use, so I'll explain what I'm trying to do...
I've made two separate lists, one for part type and one for colors, and made pull down menus based on that data. What I'm trying to do, is make a third column auto populate with the actual part number based on the two selections. I have a list, of all the possible parts, colors and numbers on a separate tab, I can combine them if needed...
I would use Access, but not everyone here has it, and I need it to be accessible to everyone...
Any help would be much appriciated!