Hi. I manage a warehouse. We do daily picks for techs based on where they are location. I have one pick sheet on its own tab. I have the part allowances on another tab.
We select the employee. That looks up his location. Then next to the part there should be a number matching the allowance for that part at that location. The older version used a VLOOKUP with a Match formula to designate the return column. I tried that and it got a #Value error because it was just counting the number of columns in the range. I've enclosed a really simplified two-tab workbook if anyone would like to teach an old dog new tricks...
Thank you for looking and any insights.
Bookmarks