If/Vlookup formula

[edins425]

Hi, I'm looking for a version of a vlookup that returns a value based on 2 matching criteria. As shown in the attached file, I've made a simple version including 3 columns. If the Department AND Budget Program in column F match the Department AND Program in Columns A and B, I'd like F4 to display the Program Purpose (column C). Seems pretty simple but I'm stuck.

Appreciate the help!

 

[dreid1011]

Give this a try:

Book1
	A	B	C	D	E	F
1	Department	Program	Program Purpose
2	Seattle Center	Cultural Space	Purpose A		Department	City Budget Office
3	Department of Neighborhoods	Departmental Indirect Costs	Purpose B		Budget Program	Departmental Indirect Costs
4	Office of Arts and Culture	Funding Programs & Partnership	Purpose C		Purpose	Purpose F
5	Office of Arts and Culture	Pooled Benefits and PTO	Purpose D
6	City Budget Office	Public Art	Purpose E
7	City Budget Office	Departmental Indirect Costs	Purpose F
Sheet5

Cell Formulas
Range	Formula
F4	F4	=XLOOKUP(F2&F3,A2:A7&B2:B7,C2:C7)

 

[edins425]

Give this a try:

Book1
	A	B	C	D	E	F
1	Department	Program	Program Purpose
2	Seattle Center	Cultural Space	Purpose A		Department	City Budget Office
3	Department of Neighborhoods	Departmental Indirect Costs	Purpose B		Budget Program	Departmental Indirect Costs
4	Office of Arts and Culture	Funding Programs & Partnership	Purpose C		Purpose	Purpose F
5	Office of Arts and Culture	Pooled Benefits and PTO	Purpose D
6	City Budget Office	Public Art	Purpose E
7	City Budget Office	Departmental Indirect Costs	Purpose F
Sheet5

Cell Formulas
Range	Formula
F4	F4	=XLOOKUP(F2&F3,A2:A7&B2:B7,C2:C7)

This works perfectly, thank you!!!

 

[dreid1011]

This works perfectly, thank you!!!

You're welcome, and happy to help.