| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup formula | Excel Discussion (Misc queries) | |||
| row lookup formula | Excel Worksheet Functions | |||
| lookup with a formula | Excel Worksheet Functions | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
| If the lookup-value is a formula | Excel Worksheet Functions | |||
Linear Mode
