• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match?

L

Lymm

Member
Hi I dont usually use big formulas so am a bit lost trying to find a solution to this request. I dont even know if it is doable. Any pointers to help much appreciated.
If Sheet1!G2:G says "save" Then lookup the Value that row in column A , then look up Sheet2! B2:B for the same value select all rows in that column with values greater than 0 an not blank
Thanks.
 
Lymm

Can you please post a sample file with an example answer
 
You must log in or register to reply here.
Back
Top