Drama Comedy Crime 20 24 69 24 45 93 50 71 24 44 25 49 25 50 119 48 25 24 20 49 24 ID No Employee 45106 Anderson, Jane 80554 Armstrong, Dan 1 90676 Ashe, Lucille 5 54209 Bell, Stephen 6 88724 Bradshaw,John 7 75657 Carrey,Julia 8 41207 Davis, Charles 9 55616 Diamond, Elizabeth 10 67842 Goodman, Paul 11 53943 Hawking, Alfred 12 43884 Hicks, Michael 13 93495 Jennings,John 14 67260 Lee, Frank 15 90909 Manning, Marilyn 16 39841 Newhart, Anna 17 59691 Putin, Julia 18 60989 Richards, Andy 19 98347 Sagan,Jessica 20 56309 Silverstone, Gloria 21 39786 Simpson, Howard 22 67922 Simpson, Meryl 23 66593 Spears,Julie 24 84583 Streep, Margaret 25 31221 West, Chuck 26 27 94 67 44 45 73 50 25 43 25 66 25 21 22 23 21 22 2 42 70 25 67 90 73 93 49 23 28 29 30 31 32 33 34 35 36 37 38 INDEX and MATCH: Find Frank's unit sales in the Drama Genre #N/A Name Units Sold Lee, Frank Nam Name Lee, Frank Genre Drama Units Sold units a. A- Merge & Center $ - % Font LZ Alignment Number fx =INDEX(A1:E25,MATCH(H24,B1:B25,1), MATCH(H25, A1:51,0)) D E F C Comedy Crime Drama INDEX - One-dimensional