Pull data from another sheet based on row number / last row

[surkdidat]

Hi

I have the following formula -

='[Tracker.xlsm]In Progress'!$A$55&" - "&'[Tracker.xlsm]In Progress'!$B$55

How can I amend this so either the row number specified (in this case Row 55) - is (preferably) a specified row number input in another cell, or (alternatively) the last row with data in on the "Tracker" sheet please?

I think the first option would be best, but I would be extremely grateful for both solutions (if possible) so I can see which woks best in reality / implement both

 

[Fluff]

How about

=LOOKUP(2,1/('[Tracker.xlsm]In Progress'!$A:$A<>""),'[Tracker.xlsm]In Progress'!$A:$A)&" - "&LOOKUP(2,1/('[Tracker.xlsm]In Progress'!$B:$B<>""),'[Tracker.xlsm]In Progress'!$B:$B)

 

[Fluff]

For the other option try

=INDEX('[Tracker.xlsm]In Progress'!$A:$A,B1)&" - "&INDEX('[Tracker.xlsm]In Progress'!$B:$B,B1)

where B1 has the row number

 

[surkdidat]

Apologies for the delay in being able to test and come back to you, both of those moore than meet what I need! Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.