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
|