Finding certain text in a column and the cell next to it.

Eamonn100

Board Regular
Joined
Nov 12, 2015
Messages
156
Hi,

On my Excel sheet I have column A full of text. I need a formula that finds/references Aaron in column A (and what ever value is in the cell next to the Aaron in column B). Aaron isn't always in the same cell and can be anywhere in column A. If the figure beside Aaron needs to go into a cell of it's own that's ok, (e.g. Formula cells E1, F1).


ABCDEF
1Paul25 Aaron65
2John68
3Mike95
4Billy78
5Max65
6Max25
7Paul54
8John78
9Aaron65
10Paul23
11Mike11

<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>


<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks.
 
Everyone stand down! Job done! I was a little burnt out yesterday before asking. Half an hour this morning and we are done. Thanks to you all as I've a few new things now to explore in excel.
 
Upvote 0

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,213,484
Messages
6,113,920
Members
448,533
Latest member
thietbibeboiwasaco

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