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

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

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

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?)