a vlookup will work on unsorted data if you add the ,false condition at the end. However, finding it in 1 of many different columns is anoter problem. Is there anyway to easily determine which column it is in, or would that need to be part of the formula?