how to search for a same name in two excel sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
i have two excel sheets, and in one sheet the server and it's owner name is
there, and in other server name is there, my requirement is can i check for
the same server name in both the excel sheets and update the field in second
excel sheet with its owner name?
 
Hi,
i have two excel sheets, and in one sheet the server and it's owner name is
there, and in other server name is there, my requirement is can i check for
the same server name in both the excel sheets and update the field in second
excel sheet with its owner name?
Click to expand...

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel version you are
using. I would suggest you include your Windows and Office version
number in the message.
 
Krishna said:
Hi,
i have two excel sheets, and in one sheet the server and it's owner name is
there, and in other server name is there, my requirement is can i check for
the same server name in both the excel sheets and update the field in second
excel sheet with its owner name?
Click to expand...

Hare Krishna,

You didn't say whether you would like to use Access to do this. If so,
create linked tables to each sheet and use an update query similar to
the following:

UPDATE S2 INNER JOIN S1
ON S2.SERVER = S1.SERVER
SET S2.OWNER = S1.OWNER


If you would like to do this with Excel this isn't the best place to ask
the question, but I would suggest VLOOKUP will probably work.

Namaste,
 
Back
Top