Hello all,
Can someone kindly verify my vlookup and trim is functionaing correctly?
I`m just a bit sceptical. I have put the formula in column M, I am looking to see if data from column L exists in columN k. cOLUMN k has an apostrophe in front, so I have used a trim function.
T
hank yu
Thanks,
R.
TRIM removes spaces, nothing else. No problem there
In your example you use the same value to lookup as in the lookup table, so it always returns a value whatever that may be.
Try
=vlookup(right(k16,13),$l$16:$l$5617,1,false)
Thank you john that's what I needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks