How to make Excel VBA to skip blank cells until a cell has a number

I have attached a spreadsheet and will need help in writing a code that will check the values in Column F and and Col C. The answers to what I need is the in column G (yellow).

Example if col C is 0, it should be blank on G, otherwise if Col C is 1, it should look for the next value in F and return the value , and the rest should be blank. Just like the way I specified it in the spreadsheet.
Any help is appreciated.

You can use the "IF" formula in column G to represent this.

eg: IF(C2=0,"", insert your column G formula here) will provide a blank index (double quote marks do this).

I want the VBA code to check the conditions of columns F and C and if the conditions are met then return the answer in column G. I have attached a spreadsheet to show you what I need.
For example: you can see that G10, G11, and G12 have values of 1.5 because in column C, C10, C11 and C12 has 1 as the number, the rest should be blank and the first condition should stop there and the next condition should start. I have the answers in the spreadsheet, I want to know how I can put that in a code

Solus...you nailed it...thanks a lot!!!