Dear Billy,
Thanks for response. But what you suggested is not what I want. I just want
that
in my daily sales report that when I put ID No. in column of IDNo. and in
Name of Column I put Name of Item that may be painting, textile and silver.
After that in Column C Cost price should be displayed automatically.

if you can that will be great help for me.

Thanks and regards.

and My Daily Sales report format is in this manner

A B C D
ID No. Name of Item Cost Price Sale Price