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