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
|