Matching Names listing Data from one Column!

[Guest]

Hey all need some help!

Data Sheet 1
Conisits of Names from
B15:B49

List data from sheet2 in column
D1549


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 D1549 blank

Thanks Ahead!

 

[Guest]

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

Regards
FSt1