# Need Help...

#### harsh90

##### New Member
Hallo all.

My name is Har**** and I am new to big formulation of formulas or VBA. Currently I have a problem in which I need to combine certain sheets in one sheets. I have given link of my sheet to see what it looks like. There are 4 sheets which contains different norms and its descreiption what they are used for. In the sheet named "TZ und Normen", its the sheet were it contain technical drawing number and the certain norms from earlier 4 sheets. In the sheet called Dashboard, this is where it should be combined. When for example, in Dashboard sheet, in front of TZ 1, when I enter the norms from sheet TZ und Normen as listed, in sheet Dashboard, it should notify me that yes the norm is present in the 4 sheets. If the norm is not there than it should notify add the norm.

MfG

Har****

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### iliace

##### Well-known Member
I hope I understand your question correctly.

On Dashboard sheet, in B4, I enter this formula: =IF(ISNUMBER((MATCH(B\$2, INDEX('TZ und Normen'!\$A\$4:\$G\$13, MATCH(\$A4, 'TZ und Normen'!\$A\$4:\$A\$13, 0), 0), 0))), "Normen", "")

Copy this formula to B4:OK13.

Each cell that has a matching value in the "TZ und Normen" sheet will display the word Normen where it is required, indicating that you have to enter a value. Otherwise, it is blank.

Does that help?

#### harsh90

##### New Member
Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

ich danke ihnen im voraus.

MfG
Har****

#### harsh90

##### New Member
Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

ich danke ihnen im voraus.

MfG
Har****

Also there are some norms for example TL 193, DIN 167, VDA 115 which are not in sheets DIN, VW, VDA, TL [DIN, VW, VDA, TL sheet have norms 1 to 100]. But as they are in TZ und Normen, it should notify in Dashboard sheet that the respective norm is not in the DIN, VW, VDA, TL sheet [Here for example TL 193. So in Dashboard it gives for example a cross or red backgroud which shows it is not in the TL sheet and so need to be added.When it is add in TL sheet, cross or red background will go and show the norm ie TL 193.Same for other]. So when I add that Norm in the respective sheet [DIN, VW, VDA, TL],than in Dashboard sheet it should again display the norm and not the message.

#### harsh90

##### New Member
I hope I understand your question correctly.

On Dashboard sheet, in B4, I enter this formula: =IF(ISNUMBER((MATCH(B\$2, INDEX('TZ und Normen'!\$A\$4:\$G\$13, MATCH(\$A4, 'TZ und Normen'!\$A\$4:\$A\$13, 0), 0), 0))), "Normen", "")

Copy this formula to B4:OK13.

Each cell that has a matching value in the "TZ und Normen" sheet will display the word Normen where it is required, indicating that you have to enter a value. Otherwise, it is blank.

Does that help?

Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

Also there are some norms for example TL 193, DIN 167, VDA 115 which are not in sheets DIN, VW, VDA, TL [DIN, VW, VDA, TL sheet have norms 1 to 100]. But as they are in TZ und Normen, it should notify in Dashboard sheet that the respective norm is not in the DIN, VW, VDA, TL sheet [Here for example TL 193. So in Dashboard it gives for example a cross or red backgroud which shows it is not in the TL sheet and so need to be added.When it is add in TL sheet, cross or red background will go and show the norm ie TL 193.Same for other]. So when I add that Norm in the respective sheet [DIN, VW, VDA, TL],than in Dashboard sheet it should again display the norm and not the message.

ich danke ihnen im voraus.

MfG
Har****

Replies
10
Views
1K
Replies
16
Views
674
Replies
0
Views
449
Replies
12
Views
939
Replies
0
Views
455

1,190,616
Messages
5,981,951
Members
439,745
Latest member
VBANewbieJohn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back