Double return formula.

[serge]

Hi,
I have this reference table in A3:C30, and when I enter a number in column E, I would like in column F,G that the 2 other numbers that correspond to that number from the reference table.

Thank you.

 

[skillilea]

You can put these formulas in F and G

=VLOOKUP(E3, A3:A30, 1, FALSE)
=VLOOKUP(E3, A3:A30, 2, FALSE)

 

[AhoyNC]

Another option.

Book2
	A	B	C	D	E	F	G
1	Reference table
2
3	0	14	1		0	14	1
4	1	21	1		9	21	9
5	2	21	2		12	31	3
6	3	21	3		21	11	3
7	4	21	4
8	5	21	5
9	6	21	6
10	7	21	7
11	8	21	8
12	9	21	9
13	10	31	1
14	11	31	2
15	12	31	3
16	13	31	4
17	14	31	5
18	15	31	6
19	16	31	7
20	17	31	8
21	18	31	9
22	19	11	1
23	20	11	2
24	21	11	3
25	22	11	4
26	23	11	5
27	24	11	6
28	25	11	7
29	26	11	8
30	27	11	9
Sheet1

Cell Formulas
Range	Formula
F3:G6	F3	=INDEX($B$3:$C$30,MATCH($E3,$A$3:$A$30,0),0)
Dynamic array formulas.

 

[serge]

Thank you guys, those formulas work very well, I appreciate your help.

 

[AhoyNC]

Glad we could help. Thanks for the feedback.

 

[skillilea]

Glad it worked...either one