i'm using a workbook to hold my data, and its entered in the order of which it receives data, so basically each new entry is added to the top of the worksheet and the first column has the ID transaction which is higher then the ones previous to it. When I use Vlookup to search the entries. I can't seem to use vlookup to search for my oldest entries. Basically ID numbers under 100 aren't being picked up anymore unless i resort my whole data sheet in ascending order. Is there anyway i can have vlookup work without having to change the order of the IDs from the way they are being entered? or is there a different command i can use?