Hos to control a formula with slicer or multiple options button?

[Fractalis]

Hi all,

Is there a way to control a formula with a button of options like a slicer but without inserting a pivot table in the process?

For example a simple VLOOKUP() which result changes depending 3 input values, so, have those 3 input values in a slicer or similar button?

Thanks for any suggestion

 

[jdellasala]

Slicers are filters and can be used on Excel Tables, Pivot Tables, and Pivot Charts. I think what you need is a Data Validation cell with a list of what you want to be used in the VLOOKUP.

Excel VBA User Defined Function To Generate A Dynamic Array - 2516.xlsm
	A	B	C	D	E	F
1	Name	Jan	Feb	Mar	Apr	May
2	Branson	80.59	88.74
3	Isiah	95.64	94.89
4	Joyce	105.42	111.85
5	Jessica	116.16	94.94
6	Emery	102.71	118.99
7	Charlie	97.38	87.01
8	Raegan	96.26	91.58
9	Olivia	118.47	109.85
10	William	121.63	104.66
11	Javier	106.51	85.1
12	Kiera	124.86	84.42
13	Kelli	105.85	109.73
14
15
16		Month
17	Name	Jan
18	Branson	80.59
19	Isiah	95.64
20	Joyce	105.42
21	Jessica	116.16
22	Emery	102.71
23	Charlie	97.38
24	Raegan	96.26
25	Olivia	118.47
26	William	121.63
27	Javier	106.51
28	Kiera	124.86
29	Kelli	105.85
Sheet5

Cell Formulas
Range	Formula
B18:B29	B18	=VLOOKUP(A18,$A$1:$H$13,MATCH($B$17,$B$1:$H$1,0)+1,0)

Cells with Data Validation
Cell	Allow	Criteria
B17	List	=$B$1:$G$1

The selection in the Data Validation list determines the column displayed.

This is even easier with 365, but I didn't know which version you're working with. Go to your Profile and define which version of Excel and which OS.