Lookup Formula
 

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

Lookup Formula
 

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

Lookup Formula
 

Did that. Formula returning #N/A. Using Lookup(A1,Spreadsheet2!A1:B14,2).
What am I missing?

"Don Guillett" wrote:


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

Lookup Formula
 

As Don suggested you really should use Help to learn about VVVVVVLookup
Try VLOOKUP(A1,Spreadsheet2!A1:B14,2,FALSE).
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bernadette" wrote in message
...
Did that. Formula returning #N/A. Using
Lookup(A1,Spreadsheet2!A1:B14,2).
What am I missing?

"Don Guillett" wrote:


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