excel - VLOOKUP / CONCATENATE "#N/A" error -


i trying put 2 columns , value sheet. if hardcode numbers vlookup works concatenate #n/a. both columns general format. not understand doing wrong.

this doing, in excel 2010:

=vlookup(concatenate($w26,w$1),sheet2!$a$1:$b$200,2,false) 

any ideas?

=vlookup(concatenate($w26,w$1)+0,sheet2!$a$1:$b$200,2,false)

someone sent me , works great. everyone.


Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -