Lookup Formula

B

Bernadette

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
 
B

Bernadette

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

Bernard Liengme

As Don suggested you really should use Help to learn about VVVVVVLookup
Try VLOOKUP(A1,Spreadsheet2!A1:B14,2,FALSE).
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match 2 fields in 2 seperate Spreadsheets and fill another column 1
Lookup help needed -- URGENT! Please! :) 0
Having Blank Cells, etc. ? 1
Appending Data from one spreadsheet to another 4
Find partial match from column A,B and fill partial match in C? 4
will Vlookup work for this... 1
Please help with matching spreadsheets 1
Multiple entries query 6

Top