I have a question on the Lookup table layout. The details are

Lookup table for Dept A carries account code and account name (in one column) and define name as DeptLookupAC
5000A01 abc
5000I01 asd
6000M02 qwe

When I select Dept A in W5, then W10 will show the lookup table. But the account name cannot show in the same vertical line as letter 'I' is smaller than letter 'M'. Is there any method to let layout look more good.

In W10, using Data Validation function =INDIRECT(VLOOKUP($W$5,DeptLookupAC,16,0))

TIA

norika