Gord Dibben wrote:
You need two VLOOKUP formulas in two cells.

uh-uh.

=VLOOKUP(D2, $A$2:$C$3,2,FALSE) entered in E2

=VLOOKUP(D2, $A$2:$C$3,3,FALSE) entered in F2

You missed my post of 2:00pm? The equivalent of

=VLOOKUP(D2, $A$2:$C$3,{2,3},FALSE) array entered in E2:F2

Alan Beban