Google sheets vlookup

[gammaves]

I have a vlookup in Google Sheets that isn't making sense to me.

=MID(A3,search("(",A3,1)+1,6)
returns 263972

=vlookup(263972,$S$3:$X$158,3,0)
returns the expected result

=vlookup(MID(A3,search("(",A3,1)+1,6),$S$3:$X$158,3,0)
returns N/A. (Did not find value '263972' in VLOOKUP evaluation.)





Does anybody know why I can't combine the two formulas? Is this just a downside to using Google?

Thanks for your help!

 

[Eric W]

I really can't say a lot about Google sheets, but in Excel, you might have an issue with comparing a text value with a numeric value. Try:

=vlookup(MID(A3,search("(",A3,1)+1,6)+0,$S$3:$X$158,3,0)

The +0 converts a number stored as text into a number.

 

[gammaves]

**** you're good!

It worked. Thanks a lot!

 

[Eric W]

Happy to help!