Home

Excel formula/function help

WendyBW
Occasional Visitor

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?

1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies