More Vlookup help

[jrisebo]

I need to lookup values in column K based on column P being yes, and description in A1. I was going to do a helper column, but seems alot of extra for nothing. I dont want to use a if statement because as I develop this, column P could get to 15-20 choices.

Bolted Wood Connection.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Select Structural
2	Dense Select Structural	10" wide		1950		1300	175		660	1800	1900000		690000	0.55		no
3	Select Structural			1700		1150	175		565	1650	1800000		660000
4	Non-Dense Select Structural			1500		1050	175		480	1600	1600000		580000
5	No.1 Dense			1200		800	175		660	1550	1800000		660000
6	No.1			1050		700	175		565	1450	1600000		580000
7	No.1 Non-Dense			950		625	175		480	1400	1400000		510000
8	No.2 Dense			850		525	175		660	1350	1600000		580000
9	No.2			800		475	175		565	1300	1400000		510000
10	No.2 Non-Dense			750		425	175		480	1250	1300000		470000
11	No.3 and Stud			475		275	175		565	750	1300000		470000
12	Dense Select Structural	12" wide		1800		1250	175		660	1750	1900000		690000	0.55		Yes
13	Select Structural			1600		1100	175		565	1650	1800000		660000
14	Non-Dense Select Structural			1400		975	175		480	1550	1600000		580000
15	No.1 Dense			1100		750	175		660	1500	1800000		660000
16	No.1			1000		650	175		565	1400	1600000		580000
17	No.1 Non-Dense			900		575	175		480	1350	1400000		510000
18	No.2 Dense			800		500	175		660	1300	1600000		580000
19	No.2			750		450	175		565	1250	1400000		510000
20	No.2 Non-Dense			700		400	175		480	1250	1300000		470000
21	No.3 and Stud			450		250	175		565	725	1300000		470000
Sheet4

 

[Automatrix]

First off, you need to un-merge your cells in column P (and ideally columns B-C and N-O as well, if you need to have formulas interact with them) and enter the appropriate value in all of them (P2 to P11 should all say "no", etc.). You can change their width if you feel that they are too small visually.

Since you're using Excel 365, you can then use XLOOKUP with multiple parameters. Example:

=XLOOKUP("Dense Select Structural"&"no",$A$2:$A$21&$P$2:$P$21,$N$2:$N$21)

 

[jrisebo]

Awesome, thanks. Got it to work.