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.