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

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