Please give further details. It is possible to use VLOOKUP and HLOOKUP
with the data not sorted - set the 4th parameter to FALSE or 0 to look
for an exact match.

Hope this helps.

Pete

On Jul 29, 11:49*am, Jessica Donadio
wrote:
Is there any other way of going about getting the results that the lookup
function obtains without the list havng to be in ascending order? *I have a
pretty large database of company's names and when I make a new record and *
input the country I want the values for postal code, subsequent postal cost,
best time to call, hour difference, etc, to all be pre-populated based on
previuos records for that country. *But my excel sheet will be subject to new
ordering a lot, so Lookup will not work. *I've found some formulas for IF but
I have more than 7 conditions. *Thank you to anyone who may be able to help
me. * * *