referencing to other cells and replacing

[theanalyst]

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

 

[Cbrine]

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.

 

[AlohaJulio]

You'll want to check out the INDEX & MATCH or VLOOKUP capabilities, check out this tip:
http://www.mrexcel.com/tip021.shtml