Match Formula With References

[hbk018]

Hello,

Maybe this is something easy but I don't know how to do it, I would like to know if is possible to use the index match formula doing a reference to a cell (drop down list), I want to bring data from another tab within the same sheet using the drop down list

 

[RasGhul]

Yes this is possible - can you post some sample data or with XL2BB?

 

[hbk018]

Yes this is possible - can you post some sample data or with XL2BB?

Sure I can!

 

[hbk018]

Yes this is possible - can you post some sample data or with XL2BB?

Copy of Break And Lunches on this Google Sheets you will be able to see what I am trying to do, please go to the tab that says "clean data" so you can see.

 

[RasGhul]

I cant click on your link from here, are you able to post some data with XL2BB

 

[RasGhul]

Since you have Office version 365, If you want to extract drop down data from a table from another tab based on column criteria maybe;

Book1
	A	B	C
1	Date	Name	Value
2	1/11/2021	Jason	100
3	2/11/2021	George	10
4	3/11/2021	Kate	20
5	4/11/2021	David	50
6	5/11/2021	Jason	60
7	6/11/2021	George	1000
8	7/11/2021	Kate	99
9	8/11/2021	David	87
10	9/11/2021	Jason	60
Data

Book1
	A	B	C
1
2	Criteria	Jason
3
4	Date	Name	Value
5	1/11/2021	Jason	100
6	5/11/2021	Jason	60
7	9/11/2021	Jason	60
8
Output

Cell Formulas
Range	Formula
A5:C7	A5	=FILTER(Table1[#Data],Table1[Name]=$B$2)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=Data!$B$2:$B$5