Excel Data Quality Toolkit: Difference between revisions

Excel Data Quality Toolkit (view source)

90 bytes added , 29 March

83

edits

@@ Line 218: / Line 218: @@
 =VLOOKUP(A1,'basis of record'!**$**A$1:$A$11,1,FALSE)
-'''Sample Results'''
+{|class="wikitable"
+|+ Sample Results
-A | B
+|-
- -- | --
+!A !! B
-MaterialEntity | MaterialEntity
+|-
-PreservedSpecimen | PreservedSpecimen
+| MaterialEntity || MaterialEntity
-FossilSpecimen | FossilSpecimen
+|-
-LivingSpecimen | LivingSpecimen
+| PreservedSpecimen || PreservedSpecimen
-MaterialSample | MaterialSample
+|-
-Preserved Specimen | #N/A
+| FossilSpecimen || FossilSpecimen
-HumanObservation | HumanObservation
+|-
-MachineObservation | MachineObservation
+| LivingSpecimen || LivingSpecimen
-fossil | #N/A
+|-
-tissue | #N/A
+| MaterialSample || MaterialSample
-MaterialCitation | MaterialCitation
+|-
+| Preserved Specimen || #N/A
+|-
+| HumanObservation || HumanObservation
+|-
+| MachineObservation || MachineObservation
+|-
+| fossil || #N/A
+|-
+| tissue || #N/A
+|-
+| MaterialCitation | MaterialCitation
+|}
@@ Line 239: / Line 251: @@
 Use a LOOKUP like the one above to get the correct basisOfRecord term for every row in your file.
-=VLOOKUP(A2,'unique basis of record'!$A$2:$B$12,2,FALSE)
+=VLOOKUP(A1,'unique basis of record'!$A$1:$B$11,2,FALSE)
 Note that the unique values to check are in column A of the unique basis of record tab and the correct replacement values are in column B of the unique basis of record tab. Also note that the value being returned is from column B indicated as the 2nd column in the array.