XLOOKUP

[maggersmentions]

Hi,

I'm using the latest version of 365 and Windows 10.

Below is an extract from a larger table but the objective is the same of extracting a small element e.g. type = 1, grp = 11p 102a giving an answer of 8. I have used XLOOKUP and I have not used the correct syntax.

Any help appreciated.

		101	101	101	102	102	102	103	103	103
		h	a	d	h	a	d	h	a	d
type	grp	101h	101a	101d	102h	102a	102d	103h	103a	103d
1	11p	0	0	0	4	8	6	35	18	18
2	11p	0	0	0	1	1	3	14	6	5
3	11p	0	0	0	2	1	1	10	8	5
4	11p	0	0	0	0	3	2	2	2	4
5	11p	0	0	0	1	3	0	8	2	3
6	11p	0	0	0	0	0	0	1	0	1
1	11m	0	0	0	4	2	2	13	2	7
2	11m	0	0	0	2	2	1	7	0	2
3	11m	0	0	0	0	0	0	3	2	1
4	11m	0	0	0	0	0	0	0	0	2

[#2 · Accepted solution]

@maggersmentions Two possible solutions on row 24. And there are probably more.

See attached.

[#3]

Riny,

Apologies in delay in responding. Excellent - thank you for your time.

@maggersmentions