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?
ExchangeMicrosoft Excel
Last Comment
exhuser
This question is too vague. Can you give your formula showing what you want done?
ASKER
Here is the formula: =IF(ISNA(VLOOKUP(D2,'Workb
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That simple, ha? Thanks a lot.