View Full Version : Solved: Match Values in Column A and Column B and if matched copy entire row

11-28-2007, 03:37 AM
Hi I have a sheet "Compare" with a list of hostnames in Column A

I also have a sheet "Compare Report" with a list of hostnames in Column A and corresponding data in columns B to M.

I want to compare hostnames from sheet "Compare" with "Compare Report" so that:

Upper lower case makes no difference, if a machine from "Compare" is found in "Compare Report" it is outputted to a new sheet "Output" and all of its corresponding values from "Compare Report" are also put into "Output"

If the hostname is not found, "not found" will be put in the "Output" sheet column B...

Appreciate your help very much!

Thx a lot