Thread: display text in one cell as a number in an adjacent cell in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
Reply With QuoteReply With Quote