Excel 2021: Formula to look for number AND decimal

[BrerRabbit]

I'm using this formula to help me look for a value in an array based on certain criteria. It works... except that it looks for the number ONLY and not the decimal. For example it will return "8" instead of "8.4".

How do I amend this formula to help me look for the decimal as well. Note that there isn't always a decimal, it can be just the number.

The filter returns the number and the decimal.

=IFERROR(LET(x,FILTER(INDIRECT(D$2),('Garden Diary'!$D$60:$D$99=$B10),"JJJ"),LOOKUP(10^10,MID(x,MIN(FIND({1,2,3,4,5,6,7,8,9,0},x&1234567890,FIND("pH",x))),{1,2})+0)),"pH Result not recorded.")

 

[Joe4]

Since we have no idea what your data looks like, I think it would be beneficial to us if you could show us some samples of your data, representing the different scenarios, and then show us your expected output from each.

 

[BrerRabbit]

I'm trying to retrieve the 8.5. The aforementioned formula is only giving me an 8. How do I retrieve the number and the decimal?

 

[Joe4]

You only posted one example. Is every entry in this exact structure?
Does the number you want always appear at the very end of the entry?
Is the number always prefaced with pH?

All these details are very important.

 

[BrerRabbit]

You only posted one example. Is every entry in this exact structure?
Does the number you want always appear at the very end of the entry?
Is the number always prefaced with pH?

All these details are very important.

The number is always prefaced with a pH. It can be anywhere in the text. As I said, this formula already extracts the number, just not the decimal.

 

[BrerRabbit]

The number is always prefaced with a pH. It can be anywhere in the text. As I said, this formula already extracts the number, just not the decimal.

Never mind. I realised that I only allowed for 2 numbers. So I extended it to allow for 5.

=IFERROR(LET(x,FILTER(INDIRECT(D$2),('Garden Diary'!$D$60:$D$99=$B10),"JJJ"),LOOKUP(10^10,MID(x,MIN(FIND({1,2,3,4,5,6,7,8,9,0},x&1234567890,FIND("pH",x))),{1,2})+0))
is supposed to be:
=IFERROR(LET(x,FILTER(INDIRECT(D$2),('Garden Diary'!$D$60:$D$99=$B10),"JJJ"),LOOKUP(10^10,MID(x,MIN(FIND({1,2,3,4,5,6,7,8,9,0},x&1234567890,FIND("pH",x))),{1,2,3,4,5})+0)).