Google sheets vlookup

gammaves

New Member
Joined
Mar 20, 2017
Messages
16
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

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,122
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.
 

Forum statistics

Threads
1,084,851
Messages
5,380,292
Members
401,660
Latest member
Zakariyya Ibrahim

Some videos you may like

This Week's Hot Topics

Top