Search option in one cell to make a quote form

how to search data in one excel cell meaning if my data shows 

0202 cat

0203 dog

1017 duck

1022 horse

 

and if i type ohr or the number that corresponds to the item so let say 1022

 

the cell will automatically generate horse or if i type 1022 it ill generate the date for horse

By: omar caraballo

Leave a Reply

Your email address will not be published. Required fields are marked *