Complex Excel Formula

I have an Excel file with 3 sheets.  One sheet contains all relative information, it is updated and copied over to the other sheets.  The last sheet is giving me problems because it is a listing of all clients who have a specific landlord.  The landlord is listed in the left column and then the clients are listed in the columns to the right.  This is the formula I am utilizing:  =VLOOKUP(A12, ‘Sheet1’!C8: I21, 5, FALSE).  I would like the NEXT client copied as well.  I know how I would do it in mail merge, but is there an excel formula that will do this?

 

 

By: Leeanne Sacino

Leave a Reply

Your email address will not be published. Required fields are marked *