Function selection

bonanza.bonanza
NewLounger
Posts: 6
Joined: 24 Jul 2021, 12:47

Function selection

Post by bonanza.bonanza »

I have attached an example of my project. I want to do the next: if I put the index number in E1, the country's name will appear in the E2 cell. Is it possible?
You do not have the required permissions to view the files attached to this post.

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Function selection

Post by StuartR »

In E2 put the formula
=INDEX($A$2:$A$21,E1)
StuartR


bonanza.bonanza
NewLounger
Posts: 6
Joined: 24 Jul 2021, 12:47

Re: Function selection

Post by bonanza.bonanza »

Thanks, it was so easy!