Link to home
Start Free TrialLog in
Avatar of exhuser
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?
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

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

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.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of exhuser

ASKER

That simple, ha? Thanks a lot.