I am using a drop down on cell C3 on sheet 1 with reference to C 2 to C 50 in sheet 2.
In D3 sheet 1, I would like to reference whatever is in D 2 to D 50 in sheet 2, depending on which item I choose in the drop down on C3.
Example:
Sheet 2:
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 1:
<tbody>
</tbody>
<tbody>
</tbody>
When choosing "Pen" in drop down on C3 I would like D3 to show "USD 5", E3 to show "Group 2" automatically etc...
Is this possible? If yes, how?
regards
Helge
In D3 sheet 1, I would like to reference whatever is in D 2 to D 50 in sheet 2, depending on which item I choose in the drop down on C3.
Example:
Sheet 2:
<tbody>
</tbody>
C | D | E | F | |
2 | Paper | USD 2 | Group 1 | No |
3 | Pen | USD 5 | Group 2 | No |
4 | Eraser | USD 3 | Group 2 | Yes |
5 | Tape | USD 7 | Group 3 | Yes |
<tbody>
</tbody>
Sheet 1:
C | D | E | F | |
3 | Drop down of C 2-50, sheet 2 | "Auto-follow" D 2-50 depending on what you choose in C3 | "Auto-follow" E 2-50 depending on what you choose in C3 | "Auto-follow" F 2-50 depending on what you choose in C3 |
3 (Example) | Pen | USD 5 | Group 2 | No |
3 (Example 2) | Eraser | USD 3 | Group 2 | Yes |
<tbody>
</tbody>
<tbody>
</tbody>
When choosing "Pen" in drop down on C3 I would like D3 to show "USD 5", E3 to show "Group 2" automatically etc...
Is this possible? If yes, how?
regards
Helge