Hi, I'm new here!
I have a table on sheet 1, and there is a number of collumns worth of information. In column R, I have a simple "Yes" or "No" list. If A cell is "Yes", I want to automatically populate the cells of sheet 2, and pull some of the entered informaiton from sheet 1 into sheet 2. Is there a way I can populate consecutive rows in sheet 2 based on "Yes". i.e. not a load of blank rows with occasion info from sheet 1.
Hope this makes sense!
Thanks
Sounds like you want this:
Lookup with multiple instances of the lookup value
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perfect!Originally Posted by Tony Valko
Thank you so much!
BTW, the IFERROR solution was best for me.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks