G Guest Nov 16, 2006 #2 Perhaps you mean something like this in say, E1: =VLOOKUP(D1,{"Text1",10;"Text2",20;"Text3",30},2,0) If D1 contains: Text2, then E1 returns: 20 --- Denno said: would love to get an example of the right formula, thanks Click to expand... Re: display text in one cell as a number in an adjacent cell in excel
Perhaps you mean something like this in say, E1: =VLOOKUP(D1,{"Text1",10;"Text2",20;"Text3",30},2,0) If D1 contains: Text2, then E1 returns: 20 --- Denno said: would love to get an example of the right formula, thanks Click to expand... Re: display text in one cell as a number in an adjacent cell in excel
