If this number has been found in a list than copy its text and value there

[theultimateking1]

I have remarkable question. Imagine this: I wrote the numbers 1 to 25 below each other in column A. In Column B I wrote a text and in column C I wrote their values in numbers (each number in column A has a different text and value next to it).
Now I want to have a formula that does the following ex: if I write number '4' in row E it will automatically look up for number '4' in column A, paste the text and value of number 4 in column F and E (the text in F and the values in E).

In other words If I write '4' in column E, It want to search in whole column A the number '4', give me the text that belongs to 4 in column B in column F and the value of column C in column G.

[TMS]

Use VLOOKUP.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Regards, TMS

[FlameRetired]

Another way if you want to do it in one formula do this in F1 and fill across.

Row\Col	A	B	C	D	E	F	G	H	I
1	1	Pears	0.59		4	4	Apples	0.48	F1 : =VLOOKUP($E1,$A$1:$C$25,COLUMNS($A:A),FALSE)
2	2	Bananas	0.61
3	3	Oranges	0.55
4	4	Apples	0.48
5	5	Kiwi	1
6	6	Plums	0.56
7	7	Lemons	0.47
8	8	Limes	0.58
9	9	Chicken	2.01
10	10	Steak	7.99
11	11	Hamburger	4.51
12	12	Peanut Butter	5
13	13	Milk	4.79
14	14	Bread	4.7
15	15	Soda	7
16	16	Ice Cream	4
17	17	Butter	3
18	18	Noodles	0.59
19	19	Soup	15
20	20	Chips	4
21	21	Coffee	8.99
22	22	Fish	6.5
23	23	Potatoes	2.89
24	24	Beans	15
25	25	Tomatoes	0.15