Look up and replace text

theboyfold

New Member
Joined
Sep 15, 2006
Messages
6
I'm trying to cross reference a cell in one worksheet and have it appear in another worksheet. Which I have managed. However, I would like the text to appear differently in both worksheets.
So in worksheet one, the value of the cell is: ME
Then in worksheet two I'd like this to appear as: Mr Excel

I've got a fair few different initials I'd like to translate, so the fix would need to bear this in mind.

I've tried it with the Vlookup function, however as I am already cross referencing this entry it doesn't seem to work!!

Any ideas?
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi

Maybe something like this

=VLOOKUP(Sheet1!B4,Sheet2!H10:I12,2,FALSE)

with b4 being MR (on sheet 1)
h10:I12 being the cross referencing codes (MR EXCEL located in cell I10)



plettieri
 

Forum statistics

Threads
1,171,579
Messages
5,876,277
Members
433,191
Latest member
Rect0425

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top