I am trying to create a workbook template that I can create order checklists from. Column A would have the product size, column B would have the product number. I have set up each cell in column A with a drop-down box to make it easier to enter the sizes, as there are 48 of them. Now what I want to do is have excel automatically insert the product number into the adjacent cell in column B. I've been looking around on this site trying to find a way to do this, but nothing has worked so far. I tried the IF function, but I'm sure you know it is limited to 7 nestings. I even tried the workaround, but it's proving to be a little too complex. I'm uploading a copy of my workbook so you can see what I've been trying. The sizes and their matching product numbers are on sheet 2.
I would appreciate any help.
Bookmarks