Lookup Cell And Return A Range Of Cells

  • I need some help with a formula please. Here is what I am looking to do:

    I have data inputted into cells a-o in rows 1-250. I want to search, lets say row 1, (I do want to search all 250 rows if that info is relevant!) and if cell m is blank then I want to return all the info from row 1 into row 260. If there IS data in cell m then I want to return nothing. Bottom line I want to return all the data in all the rows that contains nothing in cell m.

    I know a little about excel but this is just beyond my knowledge.

    Please help with a formula that could perform this function for me!

    Thanx a billion!

  • Re: Lookup Cell And Return A Range Of Cells

    Thank you Simon...

    Wisconsinscw, you are welcome to the forum, but as you will find out from looking at this and other forums, cross-posting is frowned upon. If you feel you MUST post your question on other forums, please at least post the link to all locations where the question is posted.

    At the very least, this prevents people from wasting their time answering a post that could already have been answered. This is clearly stated in the rules you agreed to you when signing up.


    There are 10 types of people in the world. Those that understand Binary and those that dont. :P

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!