Search or lookup function... attempting and failing

I am attempting to make excel search a column of random values to find the value i want, and then tell me what cell or row it was found in... the ultimate goal being to make excel copy the name (heading) of the respective row the result is found in, into this new spot... Sorry if this is kind of confusing, any help would be much appreciated. Thanks.