Formula for Outputting Value from Dropdown List

olsatch - Sep 6, 2022 at 01:38 PM
TrowaD
Posts
2900
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 12, 2022
- Sep 12, 2022 at 11:43 AM

Hello,

I need assistance with finding a way to output the value of cell based on the text it's associated with in a drop down list. Below is a screenshot

I essentially want to have value next to each trip in the column next to per the selection from the dropdown list. If anyone can help, it would be greatly appreciated. Thanks!
Windows / Chrome 105.0.0.0

1 reply

TrowaD
Posts
2900
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 12, 2022
523
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


0