# In the formula get cell value as a row number

#### motilulla

##### Well-known Member
Hello,</SPAN></SPAN>

I am using the formula below, which is FD\$6:FD\$5006 this has end row number 5006 I need it pick the last row number from the cell value of B3 like "FD\$6:FD\$"&B3 is it can be done
</SPAN></SPAN>

<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

Thank you all
</SPAN></SPAN>

Excel 2000
</SPAN></SPAN>
Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>

Last edited:

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### motilulla

##### Well-known Member
I tried to modified using INDIRECT function in the formula to get cell value of B3 but it does not seems to work please need help </SPAN></SPAN>

<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>

Last edited:

#### motilulla

##### Well-known Member
Bump...If formula is not workable may be VBA solution please </SPAN></SPAN>

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
Maybe
=IF(MAX((FD6=INDIRECT("FD\$6:FD\$"&B3))*(ROW(INDIRECT("FD\$6:FD\$"&B3))))=0,,MAX((FD6=INDIRECT("FD\$6:FD\$"&B3))*(ROW(INDIRECT("FD\$6:FD\$"&B3)))))

#### motilulla

##### Well-known Member
Maybe
=IF(MAX((FD6=INDIRECT("FD\$6:FD\$"&B3))*(ROW(INDIRECT("FD\$6:FD\$"&B3))))=0,,MAX((FD6=INDIRECT("FD\$6:FD\$"&B3))*(ROW(INDIRECT("FD\$6:FD\$"&B3)))))
Brilliant Fluff, Your formula has solved my problem. It worked fine. Thank you very much for your help</SPAN></SPAN>

Kind Regards,
</SPAN></SPAN>
Moti
</SPAN></SPAN>

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

Replies
0
Views
109
Replies
8
Views
348
Replies
4
Views
563
Replies
0
Views
443
Replies
5
Views
82

1,127,859
Messages
5,627,290
Members
416,236
Latest member
Lynchbox

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back