Aug 07 2022 01:42 AM
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
Aug 07 2022 01:51 AM
Solution=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.
Aug 07 2022 01:55 AM
Aug 07 2022 02:13 AM
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.
Aug 07 2022 02:38 AM
Aug 07 2022 09:15 AM
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.
Aug 07 2022 01:51 AM
Solution=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.