| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referenced Cell Values
Hello Excel Experts,
Looking for a formula for ColumnB/Sheet1 that will match a unique identifier in the corresponding row in ColumnA/Sheet1 to the same identifier somewhere in ColumnB/Sheet2 and then return the corresponding row value in ColumnC/Sheet2 to said ColumnB/Sheet1. Help! Thanks, Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referenced Cell Values
Chris,
In cell B2 of Sheet1, use the formula =VLOOKUP(A2,Sheet2!B:C,2,FALSE) and copy down to match column A. HTH, Bernie MS Excel MVP "Not Excelerated" wrote in message ... Hello Excel Experts, Looking for a formula for ColumnB/Sheet1 that will match a unique identifier in the corresponding row in ColumnA/Sheet1 to the same identifier somewhere in ColumnB/Sheet2 and then return the corresponding row value in ColumnC/Sheet2 to said ColumnB/Sheet1. Help! Thanks, Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referenced Cell Values
Thanks Bernie...made it work...your time is appreciated! Chris
"Bernie Deitrick" wrote: Chris, In cell B2 of Sheet1, use the formula =VLOOKUP(A2,Sheet2!B:C,2,FALSE) and copy down to match column A. HTH, Bernie MS Excel MVP "Not Excelerated" wrote in message ... Hello Excel Experts, Looking for a formula for ColumnB/Sheet1 that will match a unique identifier in the corresponding row in ColumnA/Sheet1 to the same identifier somewhere in ColumnB/Sheet2 and then return the corresponding row value in ColumnC/Sheet2 to said ColumnB/Sheet1. Help! Thanks, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need value from referenced cell | Excel Worksheet Functions | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| See where a cell is referenced | New Users to Excel | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
![Not Excelerated[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
