1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Match value in column number received from previous match

    From =?UTF-8?B?SMOla2FuIEJqw7Zya3N0csO2b@21:1/5 to All on Wed Mar 3 05:12:03 2021
    How to use MATCH when you know only the column number to lookup in?
    I know that the column to lookup in is column 7, but I cannot use it in MATCH like MATCH(1910,$g$g,0) .

    Thankful for any hints.
    HBj

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Wed Mar 3 14:37:17 2021
    Hi Hakan,

    Am Wed, 3 Mar 2021 05:12:03 -0800 (PST) schrieb Håkan Björkström:

    How to use MATCH when you know only the column number to lookup in?
    I know that the column to lookup in is column 7, but I cannot use it in MATCH like MATCH(1910,$g$g,0) .

    you could try:
    =MATCH(1900,INDEX(A:Z,,7),0)


    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?B?SMOla2FuIEJqw7Zya3N0csO2b@21:1/5 to claus...@t-online.de on Wed Mar 3 06:34:33 2021
    On Wednesday, March 3, 2021 at 3:37:20 PM UTC+2, claus...@t-online.de wrote:
    Hi Hakan,
    Am Wed, 3 Mar 2021 05:12:03 -0800 (PST) schrieb Håkan Björkström:

    How to use MATCH when you know only the column number to lookup in?
    I know that the column to lookup in is column 7, but I cannot use it in MATCH like MATCH(1910,$g$g,0) .
    you could try:
    =MATCH(1900,INDEX(A:Z,,7),0)


    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business


    Sorry, this function returns an error

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From MyVeryOwnSelf@21:1/5 to All on Mon Mar 8 14:06:07 2021
    How to use MATCH when you know only the column number to lookup in?
    I know that the column to lookup in is column 7, but I cannot use it in MATCH like MATCH(1910,$g$g,0) .

    This works for me with Excel 365 and Windows 10, and with all the relevant cells being Excel numbers:
    =MATCH(1910, $G:$G, 0)

    (I'm not clear what you mean by "... cannot use it in MATCH ..." Is an error of some kind reported?)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)