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