Paste Formula that skips a cell.

[DeanH]

I have a user that has received a file from a client that must not be altered
apart from the required edits.
The user has already discounted VLookup.
The list from the client has two rows per "site".
I need to paste a formula which looks to another file, this source file has
only one row per "site".
How can I paste the formula down the Client's site list but not have to edit
the thousands of pasted formula to align the cells. eg. the paste into say
client H4 is ok but client H6 should look to source H5, and client H5 will be
blank, Client H8 will look to source H6. How can we have the formula paste
"skip" the blank row?
Does this make sense?
Unfortuately

 

[DeanH]

Sorry for the premature cut-off.
Unfortunately I cannot get this work with any paste special option or
extracting the necessary column and work externally and patse back.
Any ideas?
DeanH

 

[GerryGerry]

Try using the following. it will need adjusting so that the indirect part
starts at the right address. Use Excel help to see what parameters are
required.

=IF(MOD(ROW(),2)=0,INDIRECT(ADDRESS(ROW()/2,1,,,"sheet2")),"")