Forum Discussion

WendyBW's avatar
WendyBW
Copper Contributor
Jan 15, 2019

Excel formula/function help

In spreadsheet A, I have a column with customer numbers (A) and a column of customer names (F). 

In spreadsheet B, I have a column with customer numbers (BX).  I want to replace the corresponding customer numbers in BX with the customer names from spreadsheet A, column F.

I've tried Index/Match and other functions and am not getting anywhere close to getting it right.

Any suggestions?

  • By formulas you can't take the value from the cell (in BX), make some calculations and return the result into the same cell.

     

    By INDEX/MATCH you may return names into another column and hide BX.

Resources