Hi All,

I am using the below formulas in one of my sheets:

G8 contains
=IF(ISNA(VLOOKUP(A8,'[4. GC & 5. DFS Volumes 0614.xlsx]4. GC'!$A$5:$H$660,8,FALSE)),"",VLOOKUP(A8,'[4. GC & 5. DFS Volumes 0614.xlsx]4. GC'!$A$5:$H$660,8,FALSE))

H8 contains
=IF(ISNA(VLOOKUP(A8,Data!$A$4:$I$2950,8,FALSE)),"",VLOOKUP(A8,Data!$A$4:$I$2950,8,FALSE))

i have tons of data in the sheet picked up from differnet workbooks/sheets etc.
some fields in column g and h have returned a blank cell.
i am trying to divide H8 by G8 but i keep getting #VALUE where there are no values in both or one of the cells in column g or h.
is there a way to get around this by either changing columns g or h or changing my divide formula which is just =H8/G8?
thanks