List of Names

[wvguy]

I am trying to get a list of names.

I would like it to look in each row from 3 to 2500 and If there is an amount listed in the Y column of that row return the names in D and E (Doe, John) of the same row

Row's 3 thru 2500

Thanks for any Help

 

[BeingYogi]

can u provide the data structure please

 

[wvguy]

can u provide the data structure please

I'm not sure what you are asking for exactly..

I have 4 sheets. I want to bring a list of names meeting the criteria from above from Sheet2 to sheet1. sorry if this isn't what you are looking for

 

[snoopyhr]

maybe something like that ?
=IF(ISNUMBER(Sheet1!Y2),Sheet1!D2&"-"&Sheet1!E2,"")

but I am sure it is more complicated .

 

[wvguy]

maybe something like that ?
=IF(ISNUMBER(Sheet1!Y2),Sheet1!D2&"-"&Sheet1!E2,"")

but I am sure it is more complicated .

It worked for the one row but when I try to put a range in it like this

Sheet1!Y3:Y2500

It doesn't work.

Thanks for the replies I think we are on the right track

 

[Trebor76]

You have to copy the formula down the required number of rows, not try and return them all in one cell.

 

[wangyuhu]

i think very easy,but i don't Understand you meaning

input you data
for example：
Y3=?
Y4=?
D3=
D4=
E3=
E4=

 

[wvguy]

Thanks for all the help. I found a page that had what I needed. Here is what I used to get the list and del the blanks

http://excel.bigresource.com/Track/excel-Nf5VLvMH/