Hi, I have a simple Costing Sheet which I use Vlookup to collect Description, UOM and unit price (see Experimental.xlsx below). This works well, I find the item code I need on the Data sheet and insert it in column A in the VLookup sheet. However as I add more Item rows to the data list it becomes increasingly more time consuming to find the Item code that I require. I thought that by adding groups I would be able to get some form of order, but as you all know VLookup requires the array to be in ascending order so if I sort into groups the Item Codes gets mixed up and VLookup does not work. Does anybody know of a way of doing this?
TIA Agro12
Experimental.xlsx
Bookmarks