one cell entry made up of two lookup results

Posted to microsoft.public.excel.programming

Orion[_2_] Orion[_2_] is offline

external usenet poster

Posts: 35

one cell entry made up of two lookup results

Thanks Bob,

it works. I remember now, that I've seen that before.....long, long
time ago.
Now I make a note of it.

Regards,
Norbert

On Tue, 22 Feb 2005 10:53:52 -0000, "Bob Phillips"
wrote:

=HLOOKUP($V$6,METHODS,43,FALSE)&"N/"&HLOOKUP($V$6,METHODS,44,FALSE)&"mm"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
force entry in cell "B" if entry made in cell "A"	Donna	Excel Discussion (Misc queries)	1	December 14th 09 02:23 PM
how to have auto calc cells be blank unless entry made	miss sass	Excel Worksheet Functions	2	July 13th 08 09:41 PM
1 cell that reflects last entry made in any other cell	computerwolf	Excel Worksheet Functions	3	February 21st 08 12:54 AM
After a date entry is made, only displaying the Day	Alec H	Excel Discussion (Misc queries)	3	February 9th 06 01:10 PM
How do I count the # of times an entry has been made in a month?	Wayne	New Users to Excel	13	December 28th 05 09:39 PM

All times are GMT +1. The time now is 02:00 PM.

Menu

About Us