video1.0<iframe src="https://www.loom.com/embed/4059a954e58b4b0d8982b6ff0a062772" frameborder="0" width="1388" height="1041" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>10411388Loomhttps://www.loom.com10411388https://cdn.loom.com/sessions/thumbnails/4059a954e58b4b0d8982b6ff0a062772-1ae0b9d7171e8502.gif1000.206Example formula: =IFNA(VLOOKUP(E2,$A$2:$B$13504,2,false)) Formula Breakdown: =IFNA(VLOOKUP(What Cell you want to scan for, The data set you want to scan & also $ signs, the column you want to return, false)