Conditional Vlookup

I am using a Vlookup on a template that I paste a large report into, then run my macro. My Vlookup data is on three separate sheets in the workbook. If there is a code "4356" in column "G" then column "H", "I", "J" are populated with CITY, STATE, and NAME from a particular store code.

Please Login or Register  to view this content.

My problem is that now,is a new Column "D" that contains the same codes. I need my lookups to do the lookup for "G" which has higher priority, but if "G" is empty use column "D" to populate CITY,STATE, NAME
Basically, If Column “G” exists then Lookup, else Lookup “D”

HTML Code: 

Thanks for any help in advance