Posted to microsoft.public.excel.worksheet.functions

dtb

external usenet poster

Posts: 3

Lookup question

I want to lookup a list of van numbers
Each driver may be assigned up to 5 vans.
example:
alonzo 123456
6789
blank
fred 4567
blank
blank
joe 34567
34566
34567

My results are

123456
6789
0
4567

I want to have a list of vans without the zeros. Can you 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
Lookup Question	CB	Excel Worksheet Functions	5	February 29th 08 05:52 PM
LOOKUP Question	WLMPilot	Excel Discussion (Misc queries)	4	December 5th 07 12:56 AM
Lookup Question	jam	Excel Worksheet Functions	3	July 2nd 06 11:58 AM
LOOKUP Question	shakey1181	Excel Discussion (Misc queries)	4	May 31st 06 01:59 PM
Lookup question	rk0909	Excel Discussion (Misc queries)	1	May 24th 06 07:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us