Quote Originally Posted by arlu1201 View Post
In the main sheet, cell B2, put this formula -
 =vlookup(A1, Source Sheet!A:B,2,0)
Awesome. Thank you. I was entering 'B' instead of '2' for the column index and left the range lookup blank.