Even I don't think there's a need for a sample sheet here!!

=VLOOKUP(B$1,C:E,{2,3},FALSE)*{1,-1}

will return the matching values from columns D & E... multiplying the D value by 1 and the E value by -1. Does anyone know if it is possible, using this sort of formula construction, to multiply the D value by 1... and to take the reciprocal of the E value.... like this (but not like this... as it doesn't do anything!!)

=VLOOKUP(B$1,C:E,{2,3},FALSE)*{1,1/1}


Yes, I can do it with 2 VLOOKUPS, of course... but is there an ELEGANT way to achieve the same result??