Previous Topic Next Topic

IF FORMULAS

Closed
Wedge - 1 Jun 2009 à 10:59
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 2 Jun 2009 à 04:38
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

Réponse 1 / 1
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
2 Jun 2009 à 04:38
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