display text in one cell as a number in an adjacent cell in excel
would love to get an example of the right formula, thanks
|
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Denno" wrote: would love to get an example of the right formula, thanks display text in one cell as a number in an adjacent cell in excel |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com