Previous Topic Next Topic

IF FORMULAS

Closed
Wedge - Jun 1, 2009 at 10:59 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 2, 2009 at 04:38 AM
Hello,
I am trying to create a formula on one page that will allow me to enter an alpha code in one cell and will return the codes description in another cell. I have create another page with a range of alpha codes in column "A" and the code descriptions in column "B". For example: If I enter "e" in the code cell of the first page, I need the formula to look on the range page in colum "A" for the alpha code "e" and return the text/description next to that code in column "B".
Any help would be appreciated.

Wedge

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 2, 2009 at 04:38 AM
Hi

Use vlookup =vlookup(lookupvalueCellAddress, 'Page 1'!DatabaseAddress,2,false)
eg. if you enter the code in A1 in page 2, In B1 you can get the description by using =vlookup(A1, 'Page 1'!$A$1:$B$100,2,false)
Change the 'Page 1 and 100 in the above example to match your figures
0

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Find word within cell & put value in adjacent
Mr.G -
BogelBot -

39 responses
Removing " false" value in "IF"
JIN -
share -

10 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses