I have a pricing grid on sheet one. On sheet two I have a worksheet and after inputting the number of shirts c:5 and the number of colors c:6, I need the selections to get the pricing from the respective entries and the pricing be in put in d:18. If the shirt number is in between the column headings then I need it to go down to the nearest entry, for instance 24 in the shirt column would need to go to the 12 column.
First time posting so if I have not mentioned something then apologies sent also.
Bookmarks