Related:
- Using a dropdown list to input a relative ref
- How to input @ in laptop - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Counter strike 1.6 cheats list - Guide
- I think suggested in messenger is a list of friends that have recently viewed your profile - Facebook Messenger Forum
- All contact number list with name - Guide
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
