 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

5 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Excel convert numbers to text with a formula

``=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. # Re: Excel convert numbers to text with a formula

Hi @Quadruple_Pawn, 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

# Re: Excel convert numbers to text with a formula

You can replace "item1" (cell I4 in the example) by "olives". If you then enter 1 in column B the formula returns "olives" in column C. All texts in column I can be changed as required.

# Re: Excel convert numbers to text with a formula

Yeahhh @Quadruple_Pawn thank you very much it worked perfectly great solution, thanks a lot
enter number return number
1 olives
2 green and black olives

# Re: Excel convert numbers to text with a formula

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.