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. It uses the "store number" in column "G" to return the Location CITY column"H", STATE column "I", and NAME column "J".

My problem is that now,I have 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

Here is what I have 
Please Login or Register  to view this content.