I need to show the text value of a cell base from the selected data on the dropdown list

[ECYOJ]

Hi!

I got this drop down list which shows the account number my problem is when a select a account number it must show in the next column the name of that account number for example if a select account number 110000 it must show in the sundries column Assets.

Please help. WorkBook1.xlsxWorkBook1.xlsx

[FDibbins]

Try this, copied down...
=IF(O8="","",VLOOKUP(O8,COA!$A$2:$B$179,2,0))

[FDibbins]

Thanks for the feedback