Getting part of name of cells in a different worksheet

[mwedikumenyanga]

Hi All!
Is there a way I can write a formula to get names from a different worksheet if I type part of that name in the active sheet.

Say Sheet1 contains cells like
1026 Wild hard nuts fruits -Named Fgl1026
1028 Wild Soft nuts fruits -Named Fgl1028

In active sheet, when I type Fgl1026, I want the next cell to left of the activecell to show Wild hard nuts fruits.
Sounds possible but how?

 

[james_arackal]

Hi,

Try to make a table first with all the codes and its description. Then use the vertical lookup function to call the description when the code is entered.

If you need more help please drop a line.