I have data populated in an excel spreadsheet with a blank line in between the data I need.
I have a vlookup formula
=VLOOKUP(E686,$K$4:$L$47,2,TRUE)
I want to populate that in those blank lines, so I need to copy the formula but skip every other line and I can't figure out how I can do this.
A google search left my brain exploded into a pile of goo on the floor.
Any excel gurus with a solution for me?
Thanks in advance!
I have a vlookup formula
=VLOOKUP(E686,$K$4:$L$47,2,TRUE)
I want to populate that in those blank lines, so I need to copy the formula but skip every other line and I can't figure out how I can do this.
A google search left my brain exploded into a pile of goo on the floor.
Any excel gurus with a solution for me?
Thanks in advance!
via International Skeptics Forum http://ift.tt/1sSgBAt
Aucun commentaire:
Enregistrer un commentaire