Current price for a selection when it is partially matched

[Drunkenight]

I am using Vlookup to check the current price I have out on a football team in the 'My Bets' spreadsheet. This works fine until a current bet is partially matched. This adds a "P" to the current bet referrence and means that I can't check the bet referrence against the 'My Bets' spreadsheet.

Does anyone know how I can check the current price I have out on a selection when the price has been partially matched?

Any ideas will be greatly appreciated.

[GaryRussell]

Use substitute function to remove the "P". This works if "P" is present or not.

eg. =VLOOKUP(VALUE(SUBSTITUTE(T5,"P","")),MyBets!A2:F50,4,FALSE)

[Drunkenight]

Thanks Gary! It works. I was missing one word "Value".

I had tried using:-

=VLOOKUP((SUBSTITUTE(T5,"P","")),MyBets!A2:F50,4,FALSE)

but it didn't work. I wondered what I was doing wrong.

Thanks again.