Excel Key in (look up function)

Question

Hi Excel Community,&nbsp;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.&nbsp;Ex: i put no. 2 in column D, then Bacolod should reflect on the column D.&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

Julius575&nbsp;
In E2:
=XLOOKUP(D2,$B$2:$B$23,$A$2:$A$23,"")
Fill down.

julius575 · Answer

HansVogelaar&nbsp;, just tried, per below figure, nothing reflects at E2.&nbsp;&nbsp;

hansvogelaar · Answer

Julius575&nbsp;
OK, that means you don't have Microsoft 365 or Office 2021, but an older version. Change the formula to
&nbsp;
=IFERROR(INDEX($A$2:$A$23, MATCH(D2, $B$2:$B$23, 0), "")
&nbsp;
and fill down.

julius575 · Answer

HansVogelaar&nbsp;, got it!another thing, column E should reflect on the route provided, this should be CMX.example, when i in input column D(MNL-CGY), CMX should be reflected in column E.&nbsp;&nbsp;

julius575 · Answer

same with the other rows base on the route

Forum Discussion

Excel Key in (look up function)

6 Replies