Goal: To create a formula that will read an input value and match it within a range of data [in a table], returning said matched row’s specified output column.

Procedure:

1. Create your reference table
   
2. Create your input table
   
3. Enter “=VLOOKUP(“  > select your lookup value (aka the value you want to cross-reference with the data in the reference table)
4. Specify the upper-left and lower right bounds of the entire reference table, being sure to note absolute/relative cell references as necessary (aka locked cell references)
5. Specify the column of the matching row to be returned
6. Define if the lookup should be approximate (aka true) or exact (false) > close the formula function > Copy as desired.

Conclusion: You should now be able to use the vertical lookup function (aka VLOOKUP) within Excel to cross-reference two arrays of data.

References:

1. Winston, Wayne L. Excel 2007: Data Analysis and Business Modeling. Redmond, WA: Microsoft Press, 2007. 11-15. Print. – [Amazon Hyperlink]

NOTE: I am in no way affiliated, sponsored, or compensated for this post from any third party. These posts are my opinion(s) and anything I link to is at my sole discretion for the benefit of my readers, not for financial gain.