Find match and return adjacent cell

C

Chris_1

New Member
Joined
Dec 23, 2024
Messages
6
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hello,

Sorry I have web version and cannot figure out how to paste actual excel example.
I am trying to figure out how to find the word JOB: and get the result next to it.
I have a constant. It is always on row 3
Problems. Not in a table. It moves columns and needs to be concatenated.
1734998272453.png

Any suggestions would be much appreciated.
 
Sort by date Sort by votes

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

B
  • Solved
return value on match of list?
Replies
1
Views
72
MARZIOTULLIO
M
J
  • Question Question
Search value in a range and return another value on the same row
Replies
6
Views
81
Peter_SSs
Peter_SSs
D
  • Solved
Using VBA to add a name to a cell
Replies
6
Views
231
deftincu
D
R
  • Solved
Avoid Repetition/Mismatch in TEXTJOIN of Cell Contents and a Named Range
2
Replies
11
Views
138
Fluff
Fluff
C
  • Question Question
FIND does not pick up phrases unless its an exact match. As explained below
Replies
1
Views
71
JamesCanale
JamesCanale

Forum statistics

Threads
1,224,864
Messages
6,181,471
Members
453,045
Latest member
Abraxas_X

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