Posted to microsoft.public.excel.worksheet.functions

William

Posts: n/a

Vertical Lookup problem

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Range Lookup - Problem	Jose M via OfficeKB.com	Excel Worksheet Functions	0	August 9th 05 04:00 AM
Range Lookup - Problem	Jose M via OfficeKB.com	Excel Worksheet Functions	0	August 9th 05 03:59 AM
Lookup Problem	Scott	Excel Worksheet Functions	0	April 18th 05 08:07 PM
Lookup Problem	Annette	Excel Worksheet Functions	1	April 16th 05 03:10 AM
Vertical lookup help needed	Have three columns R,S,T	Excel Worksheet Functions	1	December 11th 04 11:11 AM

All times are GMT +1. The time now is 05:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us