83
edits
Excel Data Quality Toolkit: Difference between revisions
→Non-standardized BasisOfRecord Values
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 216: | Line 216: | ||
'''WARNING!''' Note the $ in front of the letters and numbers that comprise the list to test against. Leaving these off may result in false errors as the test will run against blank cells if the formula is copied past row 11 (or whatever the last row number is in the list to test against), so make sure those $ are in place! | '''WARNING!''' Note the $ in front of the letters and numbers that comprise the list to test against. Leaving these off may result in false errors as the test will run against blank cells if the formula is copied past row 11 (or whatever the last row number is in the list to test against), so make sure those $ are in place! | ||
=VLOOKUP(A1,'basis of record'! | =VLOOKUP(A1,'basis of record'!'''$'''A$1:$A$11,1,FALSE) | ||
{|class="wikitable" | {|class="wikitable" | ||