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
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.