Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bernadette" wrote in message
...
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