IF FORMULAS

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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