I need help with countif and... i'm not sure - VLookup maybe?

Good morning all,
I need some help here - I have a formula that counts if column A has '044' written in it and column W is blank - all good so far.

Please Login or Register  to view this content.

Now if this brings a result above zero i would like it to list the contents of column D on the corresponding row.

For example
Column A Column D Column W
044 123456 blank
044 000000 blank

The outcome would look something like this:
2 - 123456, 000000 (there are 2 044 in column A which are blank in column W and then it lists the corresponding numbers from column D)

I hope this makes sense and someone is able to help!

Kind regards
Stuart

hi jimmisavage ,

can you upload a sample workbook with out any confidential data ,That could be help full to under stand your exact problem


Punnam

Not Sure,

But this can help you .

Formula:

Please Login or Register  to view this content.

Punnam

Originally Posted by Punnam

Not Sure,

But this can help you .

Formula:

Please Login or Register  to view this content.

Punnam

Hi Punnam,
This almost works but it doesn't include the criteria for Column W being Blank. It pulls all the information from column A.

Formula:

Please Login or Register  to view this content.

Try this
use Ctrl+ Shift+Enter

Punnam

Originally Posted by Punnam

Formula:

Please Login or Register  to view this content.

Try this
use Ctrl+ Shift+Enter

Punnam

Fantastic! That worked a treat - Thank you sooooooo much!

Hi jimmisavage ,

Thanks for the feedback , mark the thread solved by using the thread tools ,
You can also thank me by adding "Reputation" , by clicking the star button

Punnam