Forum Discussion
Excel Key in (look up function)
Hi Excel Community, Pls assist formula for below. In column D, i should key in the no. code(column B), column A should reflect on the column D, if i key in the no. code. Ex: i put no. 2 in c...
OK, that means you don't have Microsoft 365 or Office 2021, but an older version. Change the formula to
=IFERROR(INDEX($A$2:$A$23, MATCH(D2, $B$2:$B$23, 0), "")
and fill down.