one cell entry made up of two lookup results

[Orion]

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

 

[Bob Phillips]

=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]

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