display text in one cell as a number in an adjacent cell in excel

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Select multiple adjacent cells of multiple cells without selecting 11
Display entire number in cell 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Last Modified By in a cell by user 3
dragging formulas acros adjacent cells 3
Excel How to add numbers in same cell? 2
Red cell for negative numbers in Excel 1

Back
Top