R
roborat
I am doing a VLOOKUP moving out comments from a Pivot Table to separate
column. I have 115 rows, 100 of which work perfectly... but 15 of them give
me the #VALUE error stating "A value used in the formula is of the wrong data
type."
The formula I am using is
=IF(VLOOKUP(LEFT(C19,2500),$C$5:$J$64,1,FALSE)=0,"",(VLOOKUP(LEFT(C19,2500),$C$5:$J$64,1,FALSE)))
Why does it work for some but not others? Some of the ones not working have
acronyms, HR, CC'd, etc... could that be the problem-- and if so, how can I
get it to ignore them?
Thanks!
column. I have 115 rows, 100 of which work perfectly... but 15 of them give
me the #VALUE error stating "A value used in the formula is of the wrong data
type."
The formula I am using is
=IF(VLOOKUP(LEFT(C19,2500),$C$5:$J$64,1,FALSE)=0,"",(VLOOKUP(LEFT(C19,2500),$C$5:$J$64,1,FALSE)))
Why does it work for some but not others? Some of the ones not working have
acronyms, HR, CC'd, etc... could that be the problem-- and if so, how can I
get it to ignore them?
Thanks!