Jump to content


Photo

easy excel one for youse


  • Please log in to reply
2 replies to this topic

#1 Sir Tokyo Sexwale

Sir Tokyo Sexwale

    I'm a little tea pot

  • Moderators
  • 56,292 posts

Posted 16 May 2019 - 04:31 pm

want to find if a value is within a grid - usually VLOOKUP would do that but the value could be in column A, B or C. 

 

I can stack VLookups, but isn't there a better way? 

 

I only care whether the value is there, not its relative position etc 



#2 Redwire

Redwire
  • Members
  • 4,237 posts

Posted 16 May 2019 - 04:38 pm

To see the content of this post you must Register or Sign in to your account.



#3 Sir Tokyo Sexwale

Sir Tokyo Sexwale

    I'm a little tea pot

  • Moderators
  • 56,292 posts

Posted 16 May 2019 - 05:24 pm

To see the content of this post you must Register or Sign in to your account.






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users