Previous Topic Next Topic

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

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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Facebook 6 digit code
Naresh -
dwebb -

1 response