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

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

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