ExcelBanter - Matching Names listing Data from one Column!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matching Names listing Data from one Column! (https://www.excelbanter.com/excel-discussion-misc-queries/159519-matching-names-listing-data-one-column.html)

Killer

Matching Names listing Data from one Column!

Hey all need some help!

Data Sheet 1
Conisits of Names from
B15:B49

List data from sheet2 in column
D15:D49

Sheet 2

Conisits of Names from
B10:B49

Conisits of text data
AQ10:AQ49

If no data in located in AQ10:AQ49 leave data sheet 1 D15:D49 blank

Thanks Ahead!

FSt1

Matching Names listing Data from one Column!

hi
in Sheet2 D10....
=if(AQ10="","",AQ10)
Copy down.

Regards
FSt1

"Killer" wrote:

Hey all need some help!

Data Sheet 1
Conisits of Names from
B15:B49

List data from sheet2 in column
D15:D49

Sheet 2

Conisits of Names from
B10:B49

Conisits of text data
AQ10:AQ49

If no data in located in AQ10:AQ49 leave data sheet 1 D15:D49 blank

Thanks Ahead!

All times are GMT +1. The time now is 02:19 AM.