Question $9$

Using the image below, Write an XLOOKUP function using the green cell as the lookup$\_$value.

Use the column headers to determine which column to lookup and which to return.

Ignore the column headers in your cell ranges, use only relative cell references, return Not Found in case of missing result, and utilize default match type and search type by entering $",$ twice at the end of the formula.

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$],[1,$lookup$\_$value,,,,$],[2,,,,,],[3,$lookup$\_$array,column$\_1,$return$\_$column,column$\_3,$column$\_4],[4,$item#$1,2,,6,8,2$