Part C $-$ Database functions $($VLOOKUP$),$ absolute addressing, formula development and math validation

A

B

C

E

F

H

I

J

L

M

N

Jack's Animal House & Food Emporium

$\backslash$table$[[$Pet Inventory,,,,,$],[$PetID$,$Type,Name,Age,Weight $($lbs$),$Weight $($kg$),$Food Bin$],[$A$24,$DOG,Phydeaux,$2\mathrm{.}5,26\mathrm{.}5,,],[$B$33,$CAT,Fuzzy,$6\mathrm{.}5,9\mathrm{.}5,,],[$Z$02,$HORSE,Crazy$-$Man,$19\mathrm{.}0,1150\mathrm{.}0,,],[$X$11,$CAT,Fluffy,$1\mathrm{.}7,11\mathrm{.}0,,],[$A$27,$CAT,Butterball,$5\mathrm{.}5,7\mathrm{.}8,,],[$A$66,$DOG,Roxxy,$7\mathrm{.}2,45\mathrm{.}2,,],[$B$39,$FISH,Gupper,$0\mathrm{.}5,0\mathrm{.}2,,],[$B$01,$GOPHER,Toothie,$4\mathrm{.}0,0\mathrm{.}5,,],[$Z$99,$SQUID,Legs,$0\mathrm{.}0,600,,]]$

$\begin{array}{cc}\text{W}\text{h}\text{a}\text{t}we\text{l}\text{e}\text{a}\text{r}\text{n}\text{e}\text{d}in\text{t}\text{h}\text{i}\text{s}\text{T}\text{a}\text{b}\text{:}& \text{D}\text{a}\text{t}\text{a}\text{b}\text{a}\text{s}\text{e}\text{f}\text{u}\text{n}\text{c}\text{t}\text{i}\text{o}\text{n}\text{s}(VLOOKUP)\\ \text{E}\text{r}\text{r}\text{o}\text{r}\text{T}\text{r}\text{a}\text{p}\text{p}\text{i}\text{n}\text{g}(IFERROR)& \text{A}\text{b}\text{s}\text{o}\text{l}\text{u}\text{t}\text{e}Addressingin\text{f}\text{o}\text{r}\text{m}\text{u}\text{l}\text{a}\text{s}\\ \text{A}\text{l}\text{g}\text{e}\text{b}\text{r}\text{a}\text{i}\text{c}\text{f}\text{o}\text{r}\text{m}\text{u}\text{l}\text{a}\text{s}& Ctrl-{?}^{(}()())-\text{f}\text{o}\text{r}\text{m}\text{u}\text{l}\text{a}\text{v}\text{i}\text{e}\text{w}\end{array}$

$\begin{array}{cc}\text{F}\text{o}\text{o}\text{d}\text{B}\text{i}\text{n}\text{s}& ?\\ \text{D}\text{O}\text{G}& A\\ \text{C}\text{A}\text{T}& B\\ \text{H}\text{O}\text{R}\text{S}\text{E}& C\\ \text{F}\text{I}\text{S}\text{H}& D\\ \text{O}\text{T}\text{H}\text{E}\text{R}& E\end{array}$

$\backslash$table$[[$Grams$/$Pound$],[$Metric$,453\mathrm{.}92]]$

Summary

PartA

PartB

PartC

PartD