Text Data Formula

[kghisla]

Hi,

I am new in this Forum. I hope I will describe correctly my issue, as follows.
I need help on a formula:

Cell A1: 1
Cell B1: john (text)
Cell A2: 2
Cell B2: phil
Cell A3: 3
Cell B3: Mary


Cell h6: I choose a number (1,2....) that ranges accordingly to the "A"'s column.
Here the inquiry:
Cell I6: what's the formula that gets me the exact same text next to the cell's number i fill:

Example: if in cell h6 i write 1, in the cell I6 I would like it to show "John"
Likewise, if I write 2 in the cell h6, in the Cell I6 I would like to show "Phil"

thanks a lot.

Carlo

[edvwvw]

=VLOOKUP(C2,A1:B3,2)

C2 is the data that you want to search for - that data is in A and the value to lookup is in B

The data in a needs to be sorted.

edvwvw

[kghisla]

thanks a lot, you're great!!