All Hokie, All the Time. Period. Presented by

The Lounge Board

wtrva

Joined: 07/02/2006 Posts: 169
Likes: 14

What's this?

You may have hidden spaces


Wrap your "key", the value you are looking up, in a Trim(Text(A2)) etc..... and then make sure your lookup column is also text.

Try that.

(In response to this post by MP4VT2004)

Posted: 11/23/2020 at 2:44PM


+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


75
Hide This

Current Thread:
 
  Calling on all you Excel ninjas - I need some help... -- MP4VT2004 11/22/2020 8:51PM
  You may have hidden spaces -- wtrva 11/23/2020 2:44PM
  PC Load Letter ** -- bigbadbird 11/23/2020 08:22AM
  What the #$% does that mean??? ** -- MP4VT2004 11/23/2020 08:43AM
  Lookups need to be sorted from what I recall. May not be your issue, but -- Hokie Hokie 11/23/2020 01:56AM
  Make sure you anchor the area of your lookup if you are copying -- TheNuke 11/22/2020 11:29PM
  What I might do -- MrBayAreaHokie 11/22/2020 10:16PM
  Not an excel expert but is the content type consistent? E.g. string or num? ** -- HokieForever 11/22/2020 9:12PM
  The lookup values and drop down list are all text... -- MP4VT2004 11/22/2020 9:20PM
  Possible? Link -- HokieForever 11/22/2020 9:41PM

Tech Sideline is Presented By:

Our Sponsors








vm307