Could you check my code please

[ipbr21054]

Evening,
Screen shot of page supplied.

I would enter the date in column A then i would select a customer from the dropdown list in column B
Now the cells in column C,D,E should be from the database on the right hand side.

So this is the code in cell C5

=IFERROR(VLOOKUP($B5,INDIRECT("$N$4:$DB$"&COUNTA('C:\Users\Ian\Desktop\Downloads\New folder\GRASS\REMOTES ETC\DR\REMOTES ETC\DR\[DR.xlsm]INFO'!$CV:$CV)),2,FALSE),"")

What the code should be doing is looking for the name i selected from the drop down list then looking at the database return the correct address.
I ask to check my code as after putting the lookup code in the address bar etc when i then hit enter i get a windown open expecting me to select a file ?

The correct address is returned but not sure why the box opens up ?

Also after making a selection from the drop down list the address,cost & mileage seems to take too long to be entered into the cells.
As opposed to click & there entered i see the cursor going around & around as if the code is incorrect etc.

Thanks

 

[mikerickson]

Have you tried
=IFERROR(VLOOKUP($B5,$N:$DB,2,FALSE),"")

The whole column reference should be faster than looking at a closed, external workbook (that's where the window is coming from) and applying that to an volatile INDIRECT.

 

[ipbr21054]

I have now & worked a treat. Thanks.