View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion[_2_] Orion[_2_] is offline
external usenet poster
 
Posts: 35
Default 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"