Match string "Route" and then if match return corresponding cell value in another cell.

A

akmaximo83

New Member
Joined
Oct 16, 2023
Messages
1
Office Version
  1. 2011
  2. 2010
  3. 2007
Platform
  1. Windows
Dear All,
Please write an Excel formula.
Match string "Route" and then if match returns the corresponding cell value in another cell.
Thanks.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Like this?
Excel Formula: 
=INDEX(returnColumnAddress,MATCH(string,stringColumnAddress,0))
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
Index/Match Duplicate Values With No Helper Cells
Replies
3
Views
268
Domenic
D
A
  • Question Question
Longer Text Lookup within Shorter Text String
Replies
2
Views
182
Scott Huish
Scott Huish
srizki
  • Question Question
Sumifs Match Formula.
Replies
5
Views
280
dreid1011
dreid1011
L
  • Solved
AND conditional formatting
2
Replies
10
Views
429
Jeffrey Mahoney
Jeffrey Mahoney
D
  • Solved
SUM of Columns based on multiple criteria with User Form
2
Replies
15
Views
252
Alex Blakenburg
A

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top