vlookup with isblank

[djpret]

Hi

Hope you can help me below is a formula that is in 4 different cells obviously recalling a clients data into cells once the client number is chosen in E4, what I need is to adjust it so that if there is no client chosen yet in E4 that the corresponding cells be blank and not have the #n/a in it

=VLOOKUP($E$4;Customers!1:1048576;2;FALSE)


If you can help i will really appreciate it

 

[RileyC]

=iferror(formula, "")

 

[Peter_SSs]

Welcome to the MrExcel board!

Your lookup range is excessive. You are only looking in column A of 'Customers' and returning a value from column B so you definitely do not need to be referencing all 16,000+ columns. Surely you can also restrict the rows to something moderate?
So something like

=IF($E$4="";"";VLOOKUP($E$4;Customers!$A$1:$B$1000;2;FALSE)