Part of my code has stopped working

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,368
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,368
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,261
Office Version
365
Platform
Windows
Are you sure it's code & not formulae?
 

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,368
You are correct.

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

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,261
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,100,142
Messages
5,472,754
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top