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" wrote in message
...
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"
wrote:

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