Formula for Outputting Value from Dropdown List
Closed
olsatch
-
Sep 6, 2022 at 01:38 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 12, 2022 at 11:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 12, 2022 at 11:43 AM
Related:
- Formula for Outputting Value from Dropdown List
- My contacts list names - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Network cmd commands list pdf - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Sep 12, 2022 at 11:43 AM
Sep 12, 2022 at 11:43 AM
Hi Olsatch,
You are looking for the VLOOKUP function.
When I counted the cells correctly, then this is the formula:
=VLOOKUP(B21,$C$2:$D$16,2)
Drag the formula down for the other 2 trips.
Best regards,
Trowa