I am struggling with composing a formula that will take the condition in one cell (e.g., "YES") and then proceed with performing a lookup and where a match is found, return a branch store name. As an example, I have two worksheets in the workbook, with one worksheet (Detail) contains all my detailed information and the second worksheet (Branches) only contains the Branch Number, Branch Name and Branch Address.
In the Detailed worksheet I would like cell AB5 to look at AA5 and if that cell is populated with a "YES", then search the Branches worksheet cells A2:A266 and compare the results to cell C5 (Branch Number) in "Detailed" worksheet and where a match is found return the name of the branch from cells C2:C266 of the "Branches" worksheet.
Thank you for your assistance
Bookmarks