Part of my code has stopped working

[ipbr21054]

Morning,

I have a worksheet called INV that when i select the drop down arrow in cell G13 i see a list of customers names.
These names are on another worksheet called DATABASE of which is in the same workbook.
Selecting a name then copies certain cell values from the customers entered info on the DATABASE sheet like address, post code etc etc.
I have noticed that now the telephone number is not imported anymore.
The telephone number is on the worksheet DATABASE & is in column W
It should then be entered on the worksheet called INv & entered in cell N17

So i am now trying to find the code which gathers the information to enter on the INV sheet.
If i click the cell for where the customers name is then data validation i then see =INDIRECT("CUSTOMERSNAMEINV")

Now i dont know how to continue to find the code.

Please can you advise thanks

 

[ipbr21054]

I have looked for code that would copy / paste the required values but so far no luck.
I have look for code on the INV & DATABASE sheet.
Ive even looked through every module code but nothing.

Where else would the code possibly be ?

 

[Fluff]

Are you sure it's code & not formulae?

 

[ipbr21054]

You are correct.

I didnt see it before as nothing was there but the following now works,thanks

=IFERROR(IF(INDEX(DATABASE!W:W,$H$13)=0,"",INDEX(DATABASE!W:W,$H$13)),"")

 

[Fluff]

You're welcome & thanks for the feedback