Cell references in formula will not increment when filled or dragged down a column?

[Event2020]

Hi

I have the below formula that I need the cell references to increment when I drag down a column.

=IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$2),"",""&[CATraxx_Album.xlsx]Track!$H$2& "")

what i need it do do when copied downward is

=IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$2),"",""&[CATraxx_Album.xlsx]Track!$H$2& "")
=IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$3),"",""&[CATraxx_Album.xlsx]Track!$H$3& "")
=IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$4),"",""&[CATraxx_Album.xlsx]Track!$H$4& "")
=IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$5),"",""&[CATraxx_Album.xlsx]Track!$H$4& "")
and so on

I have tried selecting the starting cell in which the formula is entered (A1) then holding the left mouse button down I drag downward to select a range of cells (A1 - A100) then press Ctrl D - this just copied the formula as it is across all of the cells without incrementing the cell reference.

I also tried selecting the starting cell in which the formula is entered (A1) and then grabbing the handle in the bottom right hand corner with a left mouse click (held down) and dragging down but that did not work.

I also tried grabbing the handle with the left mouse button and holding down the Ctrl key and dragging - did not work.

I also tried right mouse down on the handle and right mouse down plus pressing the Ctrl key but 'fill series' is greyed out.

I do not know of anything else I can try.

Does anyone have any suggestions?

 

[Fluff]

Remove the second $ so that it reads $H2

 

[Marcílio_Lobão]

Event2020, Good evening.

The cell reference is LOCKED in the function.

Before: =IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$2),"",""&[CATraxx_Album.xlsx]Track!$H$2& "")

Try to use:

NOW --> =IF(ISBLANK([CATraxx_Album.xlsx]Track!H2),"",""&[CATraxx_Album.xlsx]Track!H2& "")

Is that what you want?

I hop it helps.

 

[Event2020]

Remove the second $ so that it reads $H2

Hi and thanks for your reply.

Brilliant - that did exactly what I needed.

Thanks again.

 

[Event2020]

Event2020, Good evening.

The cell reference is LOCKED in the function.

Before: =IF(ISBLANK([CATraxx_Album.xlsx]Track!$H$2),"",""&[CATraxx_Album.xlsx]Track!$H$2& "")

Try to use:

NOW --> =IF(ISBLANK([CATraxx_Album.xlsx]Track!H2),"",""&[CATraxx_Album.xlsx]Track!H2& "")

Is that what you want?

I hop it helps.

Hi and many thanks for your reply.

I appreciate it

 

[Marcílio_Lobão]

Event2020, Good morning.

Glad to have helped you.

Thanks for the feedback.