how do i calculate the total for now pants using vlookup or hlookup. every time i attempt i get the below error in picture, Please assist with explaining how to get fomulas to calculate when information are on multiple excel tabs

Order Quantitiy Product Cost \begin{tabular}{|r|r|r|r|c|c|c|c|} Hats & Gloves & Helmets & Goggles & Snow Pants Total & Hats Total & Gloves Total & Helmets Total \\ \hline 1333 & 1784 & 334 & 1430 & \#N/A & \end{tabular} \begin{tabular}{r|r|r|r|r|r|r} \hline 838 & 161 & 1116 & 334 & 10 \\ \hline 227 & 1637 & 224 & 299 & & \\ \hline 1799 & 87 & 520 & 329 & & \\ \hline 424 & 688 & 230 & 1707 & & & \\ \hline 1431 & 1990 & 739 & 891 & & & \\ \hline 1777 & 195 & 1217 & 73 & & & \\ \hline 1724 & 185 & 1179 & 1272 & & & \\ \hline 1996 & 1743 & 27 & 1218 & & & \\ \hline 384 & 790 & 195 & 878 & & & \\ \hline 909 & 1314 & 1997 & 1935 & & & \\ \hline 10 & 1325 & 55 & 1774 & & & \\ \hline 60 & 1678 & 1000 & 1058 & & & \\ \hline 1757 & 393 & 735 & 1937 & & & \\ \hline 924 & 299 & 344 & 64 & & & \\ \hline \end{tabular}