one cell entry made up of two lookup results

Hello,

is it possible to get one cell entry, which is actually made up of two
independent lookup results?

Example:

HLOOKUP($V$6,METHODS,43,FALSE) => 80

HLOOKUP($V$6,METHODS,44,FALSE) => 10

The cell entry should show following: 80N/10mm


Thank you very much.
Norbert

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Orion" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> is it possible to get one cell entry, which is actually made up of two
> independent lookup results?
>
> Example:
>
> HLOOKUP($V$6,METHODS,43,FALSE) => 80
>
> HLOOKUP($V$6,METHODS,44,FALSE) => 10
>
> The cell entry should show following: 80N/10mm
>
>
> Thank you very much.
> Norbert

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"
<[email protected]> wrote:

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