Related:
- Using a dropdown list to input a relative ref
- My contacts list names - Guide
- How to input @ in laptop - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Lg tv change input name ✓ - Smart TV Forum
- User information is error please input again - Google Chrome Forum
1 response
Hi Morse,
Take a look at my example and see if it works for you:
I used range B1:E3 to input some random data.
Cell A1 is used for dropdown menu (Data>Validate, select list and select range $B$1:$B$3.)
Cell A2 contains this formula: =VLOOKUP($A$1,$B$1:$E$3,2)
Drag the formula down to A4. Select cell A3 and change the last number of the formula (2) to 3.
Select cell A4 and change the last number to 4.
Now when you use the dropdown list to select the b the result will be bb, bbb, bbbb.
Hope this helps, if not, give an example of how your sheet looks like.
Best regards,
Trowa
Take a look at my example and see if it works for you:
b a aa aaa aaaa bb b bb bbb bbbb bbb c cc ccc cccc bbbb
I used range B1:E3 to input some random data.
Cell A1 is used for dropdown menu (Data>Validate, select list and select range $B$1:$B$3.)
Cell A2 contains this formula: =VLOOKUP($A$1,$B$1:$E$3,2)
Drag the formula down to A4. Select cell A3 and change the last number of the formula (2) to 3.
Select cell A4 and change the last number to 4.
Now when you use the dropdown list to select the b the result will be bb, bbb, bbbb.
Hope this helps, if not, give an example of how your sheet looks like.
Best regards,
Trowa