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?
ExchangeMicrosoft Excel

Avatar of undefined
Last Comment
exhuser

8/22/2022 - Mon
Saqib Husain

This question is too vague. Can you give your formula showing what you want done?
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
Saqib Husain

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
exhuser

ASKER
That simple, ha? Thanks a lot.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23