Copy Excel formula to multiple cells and modify one value

exhuser
exhuser used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Saqib Husain, SyedEngineer

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

Author

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.
Engineer
Commented:
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.
exhuser

Author

Commented:
That simple, ha? Thanks a lot.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial