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
|