4 10 MaryAnn just receives a file containing voter registration data which needs to be analyzed. The Excel worksheet lists the voter's party as an alphanumeric value labeled Pcode, but not the political party. MaryAnn has decided to use VLOOKUP to figure out the political party of each voter. She creates a lookup table with the name range partyCodes. Which of of the following formulas would provide her with the correct values? E D Political Party A 1 First 2 Smith 3 Robbins 4 Maria 5 John 6 Erika 7 Emma 8 Jessica 9 Ali B Last Fred Terry Smith Adams Johnson Angie Lie Rasheed Pcode 1 B H F G H Party Code Name A Democratic B Republican Decline to State D American Independent E Citizen Party F Communist G Conservative H Environmentalist 1 Ind. Progressive j Liberal D J D 10 11 O vlookup (C2, partyCodes, 2) O vlookup (C2, partyCodes, 2, FALSE) O vlookup (C2, partyCodes, 2, TRUE) O vlookup (C$2,partyCodes, 2,FALSE) 5 10 MaryAnn figured out the correct formula to return the political party for each voter. However, she get the #N/A! error in cell D3. Which function would you recommend she uses to handle this situation? Last Fred Terry Smith First Smith Robbins Maria John Erika Emma Jessica Ali Adams Johnson Angie Lie Rasheed Pcode A 1 B H D J D Political Party Democratic #N/A Republican Environmentalist American Independent Liberal American Independent Democratic Party Code Name A Democratic B Republican Decline to State D American Independent E E Citizen Party F Communist Conservative H Environmentalist 1 Ind. Progressive Liberal O IENA IFERROR O ERROR O VLOOKUP 6 10 What would the formula =HLOOKUP (2000, A1:E2,2, FALSE) return based on the lookup table below? A D E B 2000 1 1000 4000 5000 3000 2. A B D E