Pages

Search

Excel Help Forum - Excel General: VLookup Syntax required to look up period date if I put 'Yes' in a cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
VLookup Syntax required to look up period date if I put 'Yes' in a cell
Hi, could anyone please advise me of the Vlookup syntax to look up the current period dates from a range of period dates if I put 'Yes' in a cell? What I have is a workbook with two worksheets i.e. 'This Period' and 'Admin'. The 'Admin' tab has this finacial years dates in columns C & D...