Match Cells

[Rick]

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

 

[Guest]

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

 

[Rick]

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.








- Show quoted text -

thanks that worked
Rick