Referenced Cell Values

  • Thread starter Thread starter Not Excelerated
  • Start date Start date
N

Not Excelerated

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
 
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
 

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

vlookup (indirect, or sumproduct) using three tabs 3
Send to another sheet row by row 3
Excel Updation 5
Return Corresponding Value Based on Comparing Two Sheets of Data 6
Match two excel spread sheet using Macro 3
Getting count 3
HELP: Match values from different sheets and populate a column 3
summarize data from one spreadsheet to other spreadsheet 10

Back
Top