if b23=10 can I use the 10 of that cell to be the numeric part of cell d? So that in this case I would be meaning d10, but if b23=12 then my d cell would be d12.
You can use
See LibreOffice Help on INDIRECT.
Tested with LibreOffice 22.214.171.124 (x64); OS: Windows 10.0.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark ( → ) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow () that is on the left (to vote, you need to have karma of at least 5).