22. See the screenshot below. What function can be used in cell E5 to find the unit sales of the person selected in cell E4? (Assume that the range A1:B20 has been named lookup) =LOOKUP(E4, lookup. B.TRUE) LOOKUP(E4,lookup,B,FALSE) OVLOOKUP (E4,lookup,2,TRUE) -VLOOKUP(E4,lookup,2,FALSE) =HLOOKURE4,lookup,2,TRUE) =HLOOKUP(E4,lookup,2, FALSE) 1 Name Units sold 3 Jake 4 Jill 5 Eric 6 Alex 7 Allan 8 Derek 9 Hal 10 Harry 11 Jan 12 Carol 13 Vivian 14 Jennifer 15 Gregory 16 Dan 17 Max 18 Bob 19 Jeff 20 Wanda 21 65 110 74 68 100 81 93 Name: Vivian Units sold: 92 86 52 84 64 51 73