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?
exhuserAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Select cell. You will see a tiny black square at the bottom right corner of the cell. Just drag the tiny square as far down as required.
0
 
Saqib Husain, SyedEngineerCommented:
This question is too vague. Can you give your formula showing what you want done?
0
 
exhuserAuthor Commented:
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.
0
 
exhuserAuthor Commented:
That simple, ha? Thanks a lot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here