Working with 2 spreadsheets. Want to populate text from spreadsheet 2 into
spreadsheet 1. Need a formula to look up a value from column A in
spreadsheet 1 in any row in column A in spreadsheet 2 and extract a value
from the same row from column B in spreadsheet 2 and populate info in
spreadsheet 1. Help!

Spreadsheet 1
Column A = Number
Column B = ? (needed from Spreadsheet 1)

Spreadsheet 2
Column A = Number
Column B = Text