Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
So if your A set above is in Sheet 1 starting at A1, add the vlookup below to column B in the corresponding row. This will look up your B dataset above, assuming it's in Sheet2 starting at A1.
=Vlookup(A1,'Sheet2'!$A$1:
See attached.
Book1.xls