View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion[_2_] Orion[_2_] is offline
external usenet poster
 
Posts: 35
Default 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