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