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
Post a Comment