Sort Data into Groups

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

The data does not have to be sorted for VLOOKUP - you can use the 4th (optional) parameter set to zero or FALSE to look for an exact match, so your formula in B2 of the lookup sheet will be:

=IFERROR(VLOOKUP(A2,Data!$A$2:$D$11,3,0), " ")

Make a similar change to the formula in D2 and E2, and then you can arrange your data in whatever order you require.

Hope this helps.

Pete

Thanks Dave & Pete, that's Brilliant. I didn't think that it would be so simple.
Agro12