How to combine the 2 formula below?

mfreak009

New Member
Joined
Sep 21, 2006
Messages
8
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!
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try perhaps:

=IF(INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!G"&INDEX(G:G,MATCH("Client name",D:D,0)))>=INDIRECT("'Budget "&TEXT(S4,"dd mmm yy")&".csv'!M"&INDEX(M:M,MATCH("Client name",D:D,0))),"ALERT!", "")
 

Watch MrExcel Video

Forum statistics

Threads
1,119,083
Messages
5,576,010
Members
412,694
Latest member
Deaf1Too
Top