I am sorry to bother if its a simple question but i got a trouble doing this stuff
Here i got the Data like this
I Want results (Name of Country) in E2 if i put the number (given digits) in E1
E.g. if i put number 7 in E1, The result in E2 must be Can.
P.s, I want Formula instead of VB Code.
I am trying Index match but its not giving me results but an error. Plz help
Here i got the Data like this
A | B | C | D |
Pk | USA | UK | Aus |
1 | 2 | 3 | 4 |
Ind | Tur | Can | Nep |
5 | 6 | 7 | 8 |
I Want results (Name of Country) in E2 if i put the number (given digits) in E1
E.g. if i put number 7 in E1, The result in E2 must be Can.
P.s, I want Formula instead of VB Code.
I am trying Index match but its not giving me results but an error. Plz help