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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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,137,329
Messages
5,680,853
Members
419,935
Latest member
analyst0503

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