Please help . how to fetch for detail from another sheet for a specific value in first

You would have to use the function VLOOKUP

Syntax

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value is the string you are searching for

table_array is the sheet you are looking in but you have to specify the range. exemple : Sheet2!$A$2:$B$65535

col_index is the index of the column wich to be used when the value is found

So something along the lines of : =VLOOKUP(whatever your are looking for, Sheet2!A2:B65535, 2, FALSE)
If you need the value from another column use another number in the col_index

I am no expert but you should be able to figure out what you need from that

If the data on sheet1 starts in A2 with the machinename and problem in B2 and sheet2 starts in A2 with the machinename, B2 has the owner, C2 has the location, add in C1 the title OWNER and in D1 LOCATION.

On Sheet1 enter this formula in C2 and copy across to D2 then copy down the length of your data:

Formula:

Please Login or Register  to view this content.

I have added extra rows to accommodate extra data not mentioned.

The formula that I provided in msg #6 is wrong.
This works and is demonstrated in the attached file. The yellow highlighted entries don't have matches on Sheet2.

Formula:

Please Login or Register  to view this content.

The first formula corrected is:

Formula:

Please Login or Register  to view this content.

The second file uses the corrected version of the first formula.