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

one cell entry made up of two lookup results
 

=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

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"