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.