View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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