I have made excel sheet having the data of Items and their perches rates. I just want to know that if I enter the initial latter of the item in second sheet in same book it will reflect the full name of Item with perches rate.
for ex. items in first sheet are Car, bat, dall,
and if I enter the initial letter C in second sheet it automatically reflect the car with purchase rate.
how can it is possible,give the formula