exhuser

asked on

# Copy Excel formula to multiple cells and modify one value

Can anyone suggest how to copy a formula to multiple cells in one column and automatically modify one formula variable, which points to another column?

This question is too vague. Can you give your formula showing what you want done?

ASKER

Here is the formula: =IF(ISNA(VLOOKUP(D2,'Workbook1'!B:D,3,))

I need to copy this to multiple cells in one column and replace 'D2' with the corresponding D-column number such as D3, D4, etc.

I need to copy this to multiple cells in one column and replace 'D2' with the corresponding D-column number such as D3, D4, etc.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

That simple, ha? Thanks a lot.