referencing to other cells and replacing

theanalyst

New Member
Joined
Jan 16, 2004
Messages
28
Hello all!

I need big help with this one. What I have is a big main sheet full of answers, but the answers are coded. For example '2' may really mean 'red'. I have made a list of these codes in seperate sheets, whereby I have the given the different codes in column A and the answers (that I want to plug in the main sheet) are stored in column B.

Anyone know a formula that I can use to replace the codes with the plain-english examples?

Any help is greatly appreciated

Brad
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
Take a look at the vlookup formula in the excel help.

Here's an example

Vlookup(A1,'Sheet2!$A$1:$B$40,2,false)

This will take the value of A1 and lookup on the table 'Sheet2!$A$1:$B$40 and return the value of the 2nd column of the range 'Sheet2!$A$1:$B$40(ie. column B)

Hope this helps.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,104
Members
425,454
Latest member
khoro

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