Forum Discussion

Copper Contributor

Aug 07, 2022

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 ...

excel

OliverScheurich
Aug 07, 2022
Stella1750
=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.

PeterBartholomew1

Silver Contributor

Aug 07, 2022

Stella1750

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.