capture value of cell based on value in 2 cells to the left

[LarBar]

row #	B	C	D	E	F
	Date	Amount			Category
1	04/01/20	104.65			Insurance:Dental
2	04/01/20	13.91			Dining Out
3	04/03/30	44.71			Dining Out
4	04/03/30	50.16			Groceries - Household Items
5	04/03/20	511.90			[2016 Honda CRV - Loan]
6	04/06/20	2.10			Misc.
7	04/08/20	16.22			Dining Out

In the data above I want to extract the data in column F based on if the values in columns B & C match my find. If the values in both columns B & C match my input I want the value in Column F, same row to be entered in column D below. See the example below.
If I'm search for the Date of "04/03/30" that has a value of "50.16" then I want the value in column F to be entered. I have approx. 500 rows of data so manually doing a find> copy > paste will be too time consuming. Vlookup will not work because I need to check for 2 matches in columns B & C. I've tried working with match but it's not working.
So I match the values in columns B&C above and it enters the value in column F above into column D below

row #	B	C	D
	Find	Find	Return value formula
1	04/03/30	50.16	Groceries - Household Items

 

[CA_Punit]

Book1
	B	C	D	E	F	G
11	Date	Amount			Category
12	1	04/01/2020	104.65			Insurance:Dental
13	2	04/01/2020	13.91			Dining Out
14	3	04/03/1930	44.71			Dining Out
15	4	04/03/1930	50.16			Groceries - Household Items
16	5	04/03/2020	511.9			[2016 Honda CRV - Loan]
17	6	04/06/2020	2.1			Misc.
18	7	04/08/2020	16.22			Dining Out
19
20
21		Find	Find	Return value formula
22	1	04/03/1930	50.16	Groceries - Household Items
23
Sheet2

Cell Formulas
Range	Formula
E22	E22	=INDEX(G12:G18,LARGE((C12:C18=C22)*(D12:D18=D22)*ROW($C$12:$C$18)-ROW($C$12)+1,1))

 

[LarBar]

This did not work? I get $value!

I'm also using column names because most of the data lives on seperate worksheets within the same workbook.
So, the dates in column B match to values in "NCU_dates", values in column C "Amount" are matched with values in "NCU_amounts" the category to be returned in the equations is found in "NCU_categories"

Hope I'm not confusing the issue?

Thanks for your reply,

LarBar

 

[CA_Punit]

=INDEX(G12:G18,LARGE((NCU_dates=C22)*(Amount=D22)*ROW($C$12:$C$18)-ROW($C$12)+1,1))

I hope it solves your probelm..
Please paste the above data in cell B11.

 

[LarBar]

I think my previous help questions where confusing so here's an update
The numbers (1-5) are questions or steps on what I need to accomplish.
The attached image is a better view than the pasted in data above

1. Worksheet-1 data comes from one source, Worksheet-2 from a different source
2. Both of the worksheets are in the same workbook
3. In worksheet 2 there are 3 columns with names:
column A: ncu_dates
column B: ncu_amoounts
column F: ncu_categories

4. I need to match up the date and amounts between the
two worksheets and enter the ncu_category from worksheet2
and put it in column D in worksheet1

5. The formula would actually go in column D of worksheet-1

 

[CA_Punit]

Book1
	B	C	D	E	F	G	H	I	J	K
1	Worksheet 1						Worksheet 2
2	Date	Amount	Category				04/01/2020	13.91		Insurance
3	04/01/2020	104.65	Dinning				04/01/2020	104.65		Dinning
4	04/01/2020	13.91	Insurance				04/03/2020	50.16		Dinning
5	04/03/2020	44.71	Groceries				04/03/2020	44.71		Groceries
6
7
8
9
10
11
Sheet1

Cell Formulas
Range	Formula
D3:D5	D3	=INDEX($K$2:$K$5,MATCH(B3&C3,$H$2:$H$5&$I$2:$I$5,0))

 

[LarBar]

From the image below you can see I've made my worksheet appear like your example; I copied your formula into Cells: D3-D5 and I get #N/A ?
I've used the match function before but not with the "&" sign. Is there some "add-in" I need to install for this formula to work? I using Excel 2019-32 bit.

 

[CA_Punit]

it should work. Use Ctrl+Shift+Enter try

 

[LarBar]

That was to simple! The formula works well.

Thanks for your time & the lesson.

LarBar