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) .
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?you could try:
I know that the column to lookup in is column 7, but I cannot use it in MATCH like MATCH(1910,$g$g,0) .
=MATCH(1900,INDEX(A:Z,,7),0)
Regards
Claus B.
--
Windows10
Microsoft 365 for business
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) .
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 490 |
Nodes: | 16 (1 / 15) |
Uptime: | 76:19:45 |
Calls: | 9,678 |
Calls today: | 2 |
Files: | 13,722 |
Messages: | 6,172,686 |