I would use a CONCATINATION of the City and State, such as, Lexington_NC, or
Nashville_TN, in a column just to the left of your present City
column....and then do the looking up of your CONCATINATED data entry on
that column........

Vaya con Dios,
Chuck, CABGx3




....."William" wrote in message
...
My spreadsheet has three columns: City, State, Miles. I would like to
know
how to create a lookup in which I can put in the city, such as Lexington,
and
put in a state, such KY, and have it give me the results that is in column
three "miles." My spreadsheet looks similar to below:
City State Miles
Lexington NC 423
Nashville TN 501
Lexington KY 354
Hickory NC 645
Bristol TN 344
Lexington TN 233