Results 1 to 3 of 3

Thread: Lookup function I think!

  1. #1

    Lookup function I think!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi I have a table with names down column A. In the next columns cells are either empty or have the letter Y. What I want to do is create a table that will look down for example column B and every time it comes to a letter Y the persons name that is the row header is listed in the new table. I have had some joy but the problem I have is for each row in the data table I have to have one in the table I'm trying to create. This means I have several rows blank then someone's name and so on

  2. #2
    Try this array formula

    =IFERROR(INDEX($A$1:$A$20,SMALL(IF($B$1:$B$20="Y",ROW($B$1:$B$20)),ROW(A1))),"")

    just copy it down as far as you might need.

  3. #3
    Thank you very much I have never entered an array before still dont know the difference between entering a normal formula and an array but it works!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •