Hi,
Could someone please help with the following formula?
=IF(COUNTBLANK(A2)=0,VLOOKUP(A2,Geology!$A$2:$D$7560,4,TRUE),"")
I would like to eliminate any '0' values in my results, however many '0' values are being returned because there are many blank ("") records in row D of the Geology! tab...