Match Cells
 

Trying to Match information on two different worksheets and populate a
cell if a match is found

Worksheet A,
Column A=Server names
Worksheet B,
Column A=Server names
Column D=Need Formula that looks in Worksheet A, Column A and looks
for a match for the Server name that is in Worksheet B, Column A, Row
I'm in. if match found put in Server name.

how can I do this

thanks
Rick

Match Cells
 

on d1 Sheet A:
=VLOOKUP(A1,Sheet1!$A:$A,1,FALSE)

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Rick" wrote:

Trying to Match information on two different worksheets and populate a
cell if a match is found

Worksheet A,
Column A=Server names
Worksheet B,
Column A=Server names
Column D=Need Formula that looks in Worksheet A, Column A and looks
for a match for the Server name that is in Worksheet B, Column A, Row
I'm in. if match found put in Server name.

how can I do this

thanks
Rick

Match Cells
 

On Sep 26, 11:40 am, Michael
wrote:
on d1 Sheet A:
=VLOOKUP(A1,Sheet1!$A:$A,1,FALSE)

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.



"Rick" wrote:
Trying to Match information on two different worksheets and populate a
cell if a match is found

Worksheet A,
Column A=Server names
Worksheet B,
Column A=Server names
Column D=Need Formula that looks in Worksheet A, Column A and looks
for a match for the Server name that is in Worksheet B, Column A, Row
I'm in. if match found put in Server name.

how can I do this

thanks
Rick- Hide quoted text -

- Show quoted text -

thanks that worked
Rick