Lookup function

[flammabubble]

Hi there,

I'm certain this is incredibly simple but I'm struggling with what function to use. I want a function to search column G for all non-empty cells, and then return the value in column B and column G.

 

[Fluff]

Is this for Excel or someother spreadsheet package?

 

[bbotzong]

Have you tried the COUNTBLANK(B:B) or COUNTBLANK(G:G) function?