I need to form a single formula from the below 2:
=IF(INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!$G$10")>=INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!$M$10"),"ALERT!", "")
=VLOOKUP("Client name",D:G,4, FALSE)
Instead of using a specific cell reference ($G$10 / $M$10), i prefer to use a more dynamic reference like the vlookup formula
Thanks!
=IF(INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!$G$10")>=INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!$M$10"),"ALERT!", "")
=VLOOKUP("Client name",D:G,4, FALSE)
Instead of using a specific cell reference ($G$10 / $M$10), i prefer to use a more dynamic reference like the vlookup formula
Thanks!