View original (French)

Unable to select a matrix on VLOOKUP

CmParis Posted messages 4 Status Member -  
Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   -
Hello everyone,
I have a new PC running W10, and I simply want to perform a search!
And it's not working!
I always go through the box, select cell, then select range...
My search is on a different table. I can select my table, but as soon as I click away, I return to my original table, making it impossible to select my arguments.
The same function works fine with my Excel on W7.
I've searched everywhere, but I can't find anything, I'm desperate :o(
Thank you for your help.
Have a nice day
Cécil

Configuration: Windows / Firefox 44.0

4 answers

  1.
    Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   1 476
     
    Hello,
    Can you clarify what is meant by:
    I always go through the box, select cell, then select matrix ...

    --
    Best regards.
    The Penguin
    0
    1. CmParis Posted messages 4 Status Member
       
      Sorry, it's the "function argument" box.
      0
  2. Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   1 476
     
    Hello, yes it does say that,
    Not clear either,
    So you perform your operations exactly and this just before the "As soon as I uncheck" and then you take a screenshot that you paste into a Word document and upload the latter to https://www.cjoint.com/ and post the link...!

    --
    Regards.
    The Penguin
    0
    2. CmParis Posted messages 4 Status Member
       
      Good evening,
      Sorry to follow up! I'm still stuck on my research, when I select my matrix table (after having selected the searched cell), I can't take control to make the selection.
      Thank you for your feedback
      Best regards
      cm
      0
  3. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    Is your matrix named? If so, press F3, a dialog box will open, select the name of the matrix

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - we always learn from our mistakes.
    0
  4. Le Pingou Posted messages 12273 Registration date   Status Contributor Last intervention   1 476
     
    Hello,
    Well, the cell you're looking for isn't even in your screenshot...!
    Question: can you directly insert the coordinates of your matrix into the [Matrix table] window, yes or no?

    --
    Best regards.
    The Penguin
    0