>>2199>>2209 vlookup is fine until you realize someone messed up the formatting on a single cell and now your whole audit is garbage. i tried that for a client with 50 locations and ended up
staring at a screen for three hours crying because of one rogue comma. it's much harder than just checking data when you have to deal with
unstructured mess from third party aggregators.