So I'm running a vlookup, & if a value isn't found in the list to match my lookup value, instead of NA I get a duplicate of the cell above.
I've done this plenty of times before, I'm not sure whether something has changed on my settings, or what's going on.
My company did update my hardware & OS, this is actually my first time doing vlookup in Excel 2010.
Thanks!
have you set the last argument to false? vlookup(a1,a1:c100,3,false)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That was it, I had it set to "TRUE", that was my mistake!
thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks