searching for a cell val & returning all vals in col B of all rows the cell is found

F

fullymooned

search entire sheet for all rows that contain the cell value that is in
col B. Return the cell values of column C, D, E of all rows that
contain the cell value being searched.

A function or a macro would do

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
use month in cell date to sum all relevant cells 2
Excel VBA macro, search - accumulate - delete original 0
Evaluate Multiple Cells for any Value 1
Finding Duplicate Rows & Highlighting them 6
if val in col3 is one of 13 codes (list), apply factor to val in c 1
Lookup Formula 4
Lookup Across Multiple Rows / Columns 5

Top