Hi All,
I am confused with an excel function. I would like to use VLOOKUP but it returns False when I add IF condition to it.
=IF(F112="Metered",VLOOKUP(G112,'Water Charges'!$A$7:$B$16,2,TRUE))
I use the above formula. Anyone know where doe it go wrong? It works just fine when I delete IF condition.
Bookmarks