VLOOK UP

[0 Agios]

I am having a hard time with Vlook up
I have 2 rows of numbers and depending on a number i input on another cell i want the corresponding output on another cell
ex. if on AK47 I type 3 I want on another cell K37 the number 49

1	45
2	47
3	49
4	51
5	53
6	55
7	57
8	59
9	61
10	63
11	65
12	67
13	69
14	71
15	73
16	75
17	77
18	79
19	81
20	83
21	85
22	87
23	89
24	91
25	93
26	95

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	1	45		3	49
3	2	47
4	3	49
5	4	51
6	5	53
7	6	55
8	7	57
9	8	59
10	9	61
11	10	63
12	11	65
13	12	67
14	13	69
15	14	71
16	15	73
17	16	75
18	17	77
19	18	79
20	19	81
21	20	83
22	21	85
23	22	87
24	23	89
25	24	91
26	25	93
27	26	95
Master

Cell Formulas
Range	Formula
E2	E2	=XLOOKUP(D2,A2:A27,B2:B27)

 

[0 Agios]

Thank you this worked perfect !!!

 

[Fluff]

You're welcome & thanks for the feedback.