i want to fill data in credit account of my customer automatically when his name is entered
for example my customer name is "A" so i use this formula
i make a helper sell in which i put cutomer name "A" in L1 so here is my formula

=IF(B3:B13=$L$1,A3:A13,"")

i have got this simple formula but it leaves spaces when customer name does not comes
(L1 is customer name's cell)

i want to get rid of those empty cells which comes because of "" . so how do i do this?