| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match value in column number received from previous match
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match value in column number received from previous match
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match value in column number received from previous match
On Wednesday, March 3, 2021 at 3:37:20 PM UTC+2, 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match value in column number received from previous match
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?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| Match using array of column and row references to match with | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| Help to match number in a column | Excel Programming | |||
Hybrid Mode
