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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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,118,278
Messages
5,571,281
Members
412,374
Latest member
Nagelgal
Top