In a spreadsheet where Table$1$ is formatted as a table and contains columns "Item" and "Price", you want to use VLOOKUP and CHOOSE to retrieve the price of a specific item based on its index number. Given the formula

$=$CHOOSE$($index$,$ VLOOKUP$("$Item$1",$ Table$1,2,$ FALSE$),$ VLOOKUP$("$Item$2",$ Table$1,2,$ FALSE$)),$

which statements are correct? Check all that apply. $(2$ points$)$

$$

Check All That Apply

If index$=2,$ the function will return the price of "Item$2"$If index$=2,$ the function will return the price of "Item$2"$

VLOOKUP$("$Item$1",$ Table$1,2,$ FALSE$)$ will retrieve the price of "Item$1"$ from the second column of Table$1$VLOOKUP$("$Item$1",$ Table$1,2,$ FALSE$)$ will retrieve the price of "Item$1"$ from the second column of Table$1$

VLOOKUP$("$Item$2",$ Table$1,2,$ TRUE$)$ will return an exact match for "Item$2$"VLOOKUP$("$Item$2",$ Table$1,2,$ TRUE$)$ will return an exact match for "Item$2"$

If "Item$2"$ does not exist in Table$1,$ VLOOKUP will return #N$/$AIf "Item$2"$ does not exist in Table$1,$ VLOOKUP will return #N$/$A