Posted to microsoft.public.excel.worksheet.functions

TB@work[_2_] TB@work[_2_] is offline

external usenet poster

Posts: 14

Complex Lookup Question

Here is what my spreadsheet looks like

Load# Stop Stop Seq. Final Dest.
1234 Dayton 1 Columbus
1234 Dublin 2 Columbus

I want a formula that will look by load number, then stop seq. and end with
the location. For instance I would want to find stop seq. 1 for load 1234
to return Dayton. Thanks for your help.

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
Complex lookup	pdberger	Excel Worksheet Functions	4	December 31st 08 04:32 PM
Complex Lookup Question - Clarification?????	bevpike	Excel Worksheet Functions	2	September 20th 07 08:55 PM
Complex Lookup question.	bevpike	Excel Worksheet Functions	2	September 20th 07 07:38 PM
Complex Lookup	Jason Lepack	Excel Worksheet Functions	2	February 4th 07 04:59 PM
complex lookup	[email protected]	Excel Discussion (Misc queries)	1	December 17th 04 02:01 PM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us