Forum Discussion
Solved
Excel convert numbers to text with a formula
Hello I am new to this forum, I need to make a list in which I can write for example 1=Olives 2=Bread, I want just to write the number and Excel will type an item instead, is that possible ? thanks
=IFERROR(VLOOKUP(B4,$H$4:$I$27,2,FALSE),"")Maybe like in this example. You can enter a number (which occurs in column H) in column B and the formula returns the corresponding text in column C.
5 Replies
INDEX used by itself would suffice.
= INDEX(produce, option)With 365, one could always dress the formula up to read
WorksheetFormula = productλ(option); productλ = LAMBDA(k, IF(k>0, INDEX(produce,k), "") );Whichever route you take, be very careful not to modify the lookup table, since that would invalidate all your existing records.
=IFERROR(VLOOKUP(B4,$H$4:$I$27,2,FALSE),"")Maybe like in this example. You can enter a number (which occurs in column H) in column B and the formula returns the corresponding text in column C.
- Hi OliverScheurich, thant is exactly what I need so what should the formula says? for example can you make me an example of number 1 corresponding text olives
- Yeahhh OliverScheurich thank you very much it worked perfectly great solution, thanks a lot
enter number return number
1 olives
2 green and black olives
